topic Re: Compare two date colums in Power Query

Compare two date colums

neenu — Thu, 29 Jun 2023 17:28:28 GMT

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

Re: Compare two date colums

ray_aramburo — Thu, 29 Jun 2023 18:29:11 GMT

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.

Re: Compare two date colums

Manoj_Nair — Thu, 29 Jun 2023 23:04:01 GMT

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")

Re: Compare two date colums

edhans — Fri, 30 Jun 2023 00:04:38 GMT

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.

Re: Compare two date colums

ray_aramburo — Fri, 30 Jun 2023 14:18:17 GMT

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: