Forum Discussion
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
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.