Quick measure to calculate the difference from previous date

[sebbyp]

My datatable is organised as in the image above and i would like to calculate for each country the difference from the previous date.  How is this possible to do?

[v-caliao-msft · Accepted solution]

@sebbyp,

In DAX you can’t reference the previous row in any way because there is no order to the rows, So if you need to get previous row, you can create a rank column, and then use LOOKUPVALUE function to get it.

Rank =
RANKX (
    FILTER ( Table1, Table1[Country] = EARLIER ( Table1[Country] ) ),
    Table1[Date],
    ,
    ASC
)

PreviousScore =
LOOKUPVALUE (
    Table1[Score],
    Table1[Country], Table1[Country],
    Table1[Rank], Table1[Rank] - 1
)

Regards,

Charlie Liao 

[sebbyp]

@v-caliao-msftthank you so much for your help.  It worked perfectly and is so awesome.