Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |