Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
Solved! Go to Solution.
Its ok managed to work it out
Company Rank Previous Year:=RANKX(ALL(adTrans[TrueCompany]),CALCULATE( SUMX(RELATEDTABLE(Insertbk), [InsertNetCost]),SAMEPERIODLASTYEAR(CalendarNew[Date])))
Its ok managed to work it out
Company Rank Previous Year:=RANKX(ALL(adTrans[TrueCompany]),CALCULATE( SUMX(RELATEDTABLE(Insertbk), [InsertNetCost]),SAMEPERIODLASTYEAR(CalendarNew[Date])))
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |