If MAX or LASTDATE then 1

[dwel0120]

This should be really easy but I'm not getting it to work for reasons I can't figure out. 

I have a dataset with different dates (DATE column) and I want to add a new column that puts a 1 on the rows with the max/last date on it otherwise 0. 

[VahidDM]

Hi @dwel0120 
Please try this measure:

Last Date = 
Var _MaxDate = calculate(max(table[DATE],all(table))
return
if(table[date]=_Maxdate,1,0)

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[dwel0120]

@VahidDM  That didn't work. See error below. 

[VahidDM · Accepted solution]

Hi @dwel0120 
Please try this measure:

Last Date =
VAR _MaxDate =
    CALCULATE ( MAX ( FB_TOP_CONTRIBUTORS[DATE] ), ALL ( FB_TOP_CONTRIBUTORS ) )
RETURN
    IF ( FB_TOP_CONTRIBUTORS[date] = _Maxdate, 1, 0 )

output:

Did I answer your question? Mark my post as a solution! 

Appreciate your Kudos  !!

[dwel0120]

Thank you. That worked. I didn't see that I needed the ).