Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Stevianne
Frequent Visitor

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!

 

 

 

 

 

1 ACCEPTED SOLUTION
Anand24
Super User
Super User

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

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

Result:

Anand24_0-1679580139067.png
PBI_SuperUser_Rank@1x.png  

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

 

View solution in original post

1 REPLY 1
Anand24
Super User
Super User

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

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

Result:

Anand24_0-1679580139067.png
PBI_SuperUser_Rank@1x.png  

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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors