Previou's month's rank based on my current month measure

[RogerSteinberg]

HI,

I have the following dax measure that ranks games based on sum of sales.

How can I get the previous month's rank. 

My goal is to show whether a game has gone up/down in rank. Here's my measure for current month

Rank ALL SELECTED = 
RANKX( 
    ALLSELECTED( 'Table'),
    CALCULATE(
        SUM('Table'[Revenue])),
    , DESC, Dense 
    )
    

[parry2k · Accepted solution]

@RogerSteinberg As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.

https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-ca...

and from date dimension add a measure for previous month rank

Rank Previous Month = 
CALCULATE ( [Rank Measure], DATEADD ( DateTable[Date], -1, MONTH )

OR

Rank Previous Month = 
CALCULATE ( [Rank Measure], PREVIOUSMONTH ( DateTable[Date] )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!