enddate before or after today's date?

[Stevianne]

I have a column with enddates. And I have a column with date today.

I want to make a measure if enddate is before or after today's date.

I tried below:

IF (enddate) < (today), "yes"))

it doesn't work ad I have to make use of type Text or format. 

Any ideas how I can make this work?

thanks in advance!

[Anand24 · Accepted solution]

Hi @Stevianne ,
Please use below DAX in a calculated measure:

Date Check = IF(MAX(Table[EndDate]) < MAX(Table[Today]),"Yes","No")

Result:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn