Forum Discussion

neenu's avatar
neenu
Regular Visitor
3 years ago

Compare two date colums

Hi I have 2 date columns. I need to find out which date is greater than other.please suggest a solution
Need Help
Manoj_Nair's avatar
Manoj_Nair
Solution Supplier
3 years ago

neenu- Check this out, let me know if this works.

Date Measure = 
VAR Date1 = MAX('Table'[Date Column 1])
VAR Date2 = MAX('Table'[Date Column 2])
RETURN
IF(Date1 > Date2, "Date Column 1", "Date Column 2")
ray_aramburo's avatar
ray_aramburo
Super User
3 years ago

Just chirping in here, you can actually return the dates using the varia

Date Measure = 
VAR Date1 = MAX('Table'[Date Column 1])
VAR Date2 = MAX('Table'[Date Column 2])
RETURN
IF(Date1 > Date2, Date1, Date2)

ble, see: