Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |