Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have to create a new column named 'Result'. Output will be 1 for distinct rows when all the below three columns are considered and the other rows as 0.
Input:-
Output will have the below additional column:-
Result
1
0
1
0
Solved! Go to Solution.
Such things should be dealt with in the ETL layer (for instance, in PowerQuery or SQL), not in DAX. DAX does not have a notion of order. To DAX row 1 and 2 are INDISTINGUISHABLE as are rows 3 and 4.
Best
Darek
Such things should be dealt with in the ETL layer (for instance, in PowerQuery or SQL), not in DAX. DAX does not have a notion of order. To DAX row 1 and 2 are INDISTINGUISHABLE as are rows 3 and 4.
Best
Darek
Thanks Darek
User | Count |
---|---|
55 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
83 | |
54 | |
39 | |
21 | |
15 |