The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
So I creadted a measure to Rank each ID based on their sales/month by using Rankx.
Now I tried to calculated the difference between each rank? Like Rank2 is 2 less than rank 1, rank 3 is 1 less than rank 2 etc etc?
Thanks in advance
https://learn.microsoft.com/en-us/dax/rankx-function-dax
@Kaii refer to the above documentation. Hope it helps.
User | Count |
---|---|
81 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |