Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
Can someone please help with the following - I need to Rank Customer ID by SalesDate Desc.
The Fact table I have has more than 10K customers and each has multiple sales records in the same day. Same day sales shall be ranked the same rank.
Solved! Go to Solution.
Hi @hassanh2
You can add calculated column with DAX Formula:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @Ritaf1983
Thank you for your support, but unfortunately the DAX you sent didnt return the result what I was looking for. In some cases the rank started from 2, also sometimes the rank was not consistent 1,2,4,7,...etc. I tried by adding Dense to your DAX but still didn't solve the issue.
Hi @hassanh2
You can add calculated column with DAX Formula:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @hassanh2
Did you download my linked file?
I checked it again now, and the results are correct...
User | Count |
---|---|
119 | |
95 | |
87 | |
73 | |
65 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |