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

4 Replies

  • ray_aramburo's avatar
    ray_aramburo
    Super User
    3 years ago

    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. 

  • 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:

  • edhans's avatar
    edhans
    Community Champion
    3 years ago

    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.