topic Re: If MAX or LASTDATE then 1 in DAX Commands and Tips

If MAX or LASTDATE then 1

dwel0120 — Wed, 25 Aug 2021 21:26:37 GMT

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.

Re: If MAX or LASTDATE then 1

VahidDM — Thu, 26 Aug 2021 01:23:15 GMT

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 !!

Re: If MAX or LASTDATE then 1

dwel0120 — Thu, 26 Aug 2021 13:56:58 GMT

VahidDM That didn't work. See error below.

Re: If MAX or LASTDATE then 1

VahidDM — Thu, 26 Aug 2021 23:56:10 GMT

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 !!

Re: If MAX or LASTDATE then 1

dwel0120 — Fri, 27 Aug 2021 12:50:44 GMT

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