Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have several tables.
I want to create a new empty table, then add a new column from another table based on some filters, such as
Table A
Date Title
May-1 Title-1
May-1 Title-2
May-1 Title-3
May-2 Title-4
I want to create a new table C, and add a new column from table A[title] which A[Date]=May-1.
How can I do?
Thank you!
New Table under modeling and input formula:
TableC= CALCULATETABLE(TableA, TableA[Date] = MAY-1)
Thank you @Anonymous
I just want to get one column, in my example is Title, to the new table. and the condition may have several, in my example, is only one, TableA[Date]=May-1
TableC= SUMMARIZECOLUMNS(TableA[Title], FILTER(TableA, TableA[Date] = MAY-1))
Hello @Anonymous
thank you.
it' did not work in Power Query Editor. The function SUMMARIZECOLUMNS was not recognized.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |