Forum Discussion

Stevianne's avatar
Stevianne
Frequent Visitor
3 years ago
Solved

enddate before or after today's date?

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!

 

 

 

 

 

Need Help
  • Anand24's avatar
    Anand24
    3 years ago

    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

     

1 Reply

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    3 years ago

    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