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