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 Rank:=RANKX(ALL(adTrans[TrueCompany]), SUMX(RELATEDTABLE(Insertbk), [InsertNetCost]))

 

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])))

1 Reply

  • 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])))