Forum Discussion
edwardroa
4 years agoHelper I
return latest date between 2 date columns
Hi there,
I am struggling to find an efficient DAX formula to give me a column which contains the latest date from 2 date columns.
For example, the below table is my data source and the 2 columns I would like to use are "Lease End Date" & "Lease Secondary End Date":
I would like to add the below column highlighted as desired result in Power BI?
Please help me solve, I've been trying for the last 2 hours with no easy solution found yet.
Thank you,
Edward
Max([Lease End Date],[Lease Secoundary End Date])
3 Replies
- vapid128Solution Specialist
Max([Lease End Date],[Lease Secoundary End Date])