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 need to create a Dim table based on fact, and I need to avoid to use power query.
What i'm trying to get it's a DAX that allows me to select some columns from a table, and gives me back just the unique value.
Something you can easilly do by selecting the two column and type "remove duplicates" in power query.
Doing it in DAX would let me have a lighter file
Here an example
From
A | B | C |
Red | 2 | big |
Red | 2 | Small |
Jellow | 1 | Big |
I need to obtain
AB
A | B |
Red | 2 |
Jellow | 1 |
Solved! Go to Solution.
Hi @GianlucaM,
This line should help you to achieve the required outcome:
New Table = SUMMARIZE ( 'Table', 'Table'[A], 'Table'[B] )
Best Regards,
Alexander
Hi @GianlucaM,
This line should help you to achieve the required outcome:
New Table = SUMMARIZE ( 'Table', 'Table'[A], 'Table'[B] )
Best Regards,
Alexander
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 |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
16 | |
13 |