Forum Discussion

kalspiros's avatar
kalspiros
Helper I
3 years ago
Solved

Measure for MAX dates

Hello everybody.   Just finished reading the Definitive Guide to DAX therefore, I feel rather humilated posing this question. I think it's a super easy one but I'm just out of time with that repor...
Need Help
  • kalspiros's avatar
    kalspiros
    3 years ago

    Done!

    measure 1:=VAR tablFirst=SUMMARIZE('Time Off','Time Off'[Person])
VAR tabl=ADDCOLUMNS(tablFirst,"lastAvailable", CALCULATE(SUM('Time Off'[Available]),LASTDATE('Time Off'[End])))
VAR LatestRemain=CALCULATE(AVERAGEX(tabl, [lastAvailable]))
RETURN
IF(LatestRemain=0,BLANK(),IF(LatestRemain<0,MROUND(LatestRemain,-0.5),MROUND(LatestRemain,0.5)))
kalspiros's avatar
kalspiros
Helper I
3 years ago

Done!

measure 1:=VAR tablFirst=SUMMARIZE('Time Off','Time Off'[Person])
VAR tabl=ADDCOLUMNS(tablFirst,"lastAvailable", CALCULATE(SUM('Time Off'[Available]),LASTDATE('Time Off'[End])))
VAR LatestRemain=CALCULATE(AVERAGEX(tabl, [lastAvailable]))
RETURN
IF(LatestRemain=0,BLANK(),IF(LatestRemain<0,MROUND(LatestRemain,-0.5),MROUND(LatestRemain,0.5)))