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 Everyone,
I need some assistance with getting ranks by month. Here is an example of my data:
I am trying to get a new column with the rank for each customer based on sales per month. So I can rank customers from 1 to 5 for each month.
Solved! Go to Solution.
@Jaime123,
Create the following column in your table and check if you get expected result.
RankColumn = RANKX(FILTER(Table,Table[Month]=EARLIER(Table[Month])),Table[Sales],,DESC,Dense)
Regards,
Lydia
@Jaime123,
Create the following column in your table and check if you get expected result.
RankColumn = RANKX(FILTER(Table,Table[Month]=EARLIER(Table[Month])),Table[Sales],,DESC,Dense)
Regards,
Lydia
Thanks for your help Lydia!
Hi,
Try this calculated field formula
=RANKX(ALL(Data[Customer Name]),[Revenue])
I have assumed that Revenue is a field you have computed as the sum of the sales column in your Data Table.
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |