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.
HI,
I would like to create a simple table based on another table, it must pull following columns where "Column A" should be uniques (like an excel pivot table)
Column A (unique values)
Colunm B (Can be first)
Column C (Can be first)
Column D (Can b first)
The purpose is to use this as a master table and thereby link other tables to its unique column A values
Thanks
Kristoffer
Solved! Go to Solution.
Hi Kristofferaabo,
To create a new table, in dax, you can use summarize(), selectcolumns(), addcolumns().
To achieve distinct values in column A oin the calculate table, you can use summarize function like pattern below:
calculate table = UNION ( SUMMARIZE ( old_table1, old_table1[column_need_to_be_distinct], "column1", SUM ( old_table1[column1] ) ), SUMMARIZE ( old_table2, old_table2[column_need_to_de_distinct], "column2", SUM ( old_table2[column2] ) ) )
Also refer to DAX summarize here:https://msdn.microsoft.com/en-us/query-bi/dax/summarize-function-dax
Regards,
Jimmy Tao
Hi Kristofferaabo,
So you want to duplicate values in column A, right? You can refer to this case:
Regards,
Jimmy Tao
Hi @v-yuta-msft
Thanks for your reply. No I'm nor interested to have duplicates in my new column (column A).
This new table must only return distinct values from the other table
Thanks
Kristoffer
Hi Kristofferaabo,
To create a new table, in dax, you can use summarize(), selectcolumns(), addcolumns().
To achieve distinct values in column A oin the calculate table, you can use summarize function like pattern below:
calculate table = UNION ( SUMMARIZE ( old_table1, old_table1[column_need_to_be_distinct], "column1", SUM ( old_table1[column1] ) ), SUMMARIZE ( old_table2, old_table2[column_need_to_de_distinct], "column2", SUM ( old_table2[column2] ) ) )
Also refer to DAX summarize here:https://msdn.microsoft.com/en-us/query-bi/dax/summarize-function-dax
Regards,
Jimmy Tao
Why not do this with groupby in Power Query
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |