Forum Discussion
Solved
Getting Max on Date across columns
Hi, I have in my table, 6 date columns in a table. I am trying to create a column that captures the max of these 6 date columns. But when i select the columns and try to click on Max (under statist...
Do you want to do this in Power Query or in DAX?
In Power Query you would create a list of the column names you want to compare, and then do a List.Max()
In DAX you would use multiple embedded MAX() functions
MAX([Date1],MAX([Date2],Max(Date3,Date4))) etc
Hi PBI5851 ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.