Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

second latest value

Hi guys I am quite new to Power BI and I am struggling now with getting the value from the second latest date. So i have a table "Gesamt"  like the following   Name Code Datum Gewicht DIFFD...
Need Help
Tips and Tricks
mh2587's avatar
mh2587
Super User
2 years ago
//Try this 
DifferenceSecondLatestLast = 
VAR LatestRank = RANKX(ALL(Gesamt), CALCULATE(AVERAGE(Gesamt[DIFF Date])))
VAR SecondLatestRank = LatestRank - 1

RETURN
CALCULATE(
    AVERAGE(Gesamt[Gewicht]),
    FILTER(ALL(Gesamt), Rank IN {LatestRank, SecondLatestRank})
) -
CALCULATE(
    AVERAGE(Gesamt[Gewicht]),
    Rank = LatestRank
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi

if I try this, I got an error message (as in the picture). 

Even if I put the "Rank" in [ ] to define it's the measure,  it's not working. 

Also the "Latest Rank" does not define the latest rank, right? IS there a "Max" missig? 

 

Thanks