Compare two date colums

[neenu]

Hi I have 2 date columns. I need to find out which date is greater than other.please suggest a solution

[edhans]

If you want to do this in Power Query, there are several ways. If you want to know which is larger:

if [Date1] > [Date2] then "Date 1" else "Date 2"

If you just want to return the largest date, then

List.Max({[Date1], [Date2]})

The {} brackets put the Date1 and Date2 field in a list and returns the largest. 

In DAX, it is similar:

IF(
   Table[Date1] > Table[Date2],
   "Date 1",
   "Date 2"
)

Or just returning the largest:

MAX(Table[Date1],Table[Date2])

You could substitute measures for those table[date] fields depending on what your report is doing. 

[Manoj_Nair]

@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]

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:

[ray_aramburo]

You have 2 options, both simple:

1) Create a calculated column with DAX in Power BI Desktop: DateEvaluation = IF(Table[Date1] > Table[Date2], "Greater", "Not Greater")

2) In Power Query create a Conditional column with the same logic using the UI for conditional columns.