Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Rank Varience

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

    Its ok managed to work it out

     

    Company Rank Previous Year:=RANKX(ALL(adTrans[TrueCompany]),CALCULATE( SUMX(RELATEDTABLE(Insertbk), [InsertNetCost]),SAMEPERIODLASTYEAR(CalendarNew[Date])))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Its ok managed to work it out

 

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