Rank Varience

[Anonymous]

Hi,

How would I work out the rank varience in DAX.  I have it under year on table but I want to say if it was rank 5 last year and rank 1 this year it is +4.

My Rank code is

Company Rank:=RANKX(ALL(adTrans[TrueCompany]), SUMX(RELATEDTABLE(Insertbk), [InsertNetCost]))

[Anonymous · Accepted solution]

Its ok managed to work it out

Company Rank Previous Year:=RANKX(ALL(adTrans[TrueCompany]),CALCULATE( SUMX(RELATEDTABLE(Insertbk), [InsertNetCost]),SAMEPERIODLASTYEAR(CalendarNew[Date])))