Forum Discussion

Jaime123's avatar
Jaime123
Regular Visitor
8 years ago
Solved

Ranked Customers by Month

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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.