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

     

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