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

Anonymous's avatar
Anonymous
Not applicable
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

Jaime123's avatar
Jaime123
Regular Visitor
8 years ago

Thanks for your help Lydia!