Forum Discussion
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 statistics) it is greyed out.
I tried this approach too Solved: Get MAX value of dates across multiple columns - Microsoft Fabric Community. But after converting to whole number and selecting the columns, the Statistics option is greyed out completed.
Any recommendations on how to achieve this.
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
4 Replies
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.Hi PBI5851 ,
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.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.
