Hi, Need some help. Supposedly List.Max should work on Dates right? Like List.Max([Date Column]). I have a column of Date type and I tried to Add Column with the formula List.Max([Date Column]) but it's giving me this error: Expression.Error: We cannot convert the value #date(2017, 10, 31) to type List.Details:Value=10/31/2017Type=Type So I might be missing something here...

Hi ovetteabejuela,As I tested, you need to create the date column as a list, then use it in List.Max(). I have the following sample table. 2. Create a custom column using the formula. =List.Max(#"Changed Type"[Date]) 3. You will get the expected result as follows.Best Regards,Angelia

Power Query: List.Max doesn't work on Date | Microsoft Fabric Community

Forum Discussion

Related content

M-Query - List.Max with Condition/Filter

Issue with List.Max ([Date]) in power query

Query Editor: Custom column, List.Max, formula

Power Query: List.Max dosn't return max value

Conditional List.max