Forum Discussion
AmudhaKumaran
5 years agoHelper I
M code - List.Min
Hi I'm trying to find the minimum date from a column which is in 'Date' datatype using M code List.Min function. But getting the below error. Please help. Error: Cannot convert to number.
Anonymous
5 years agoNot applicable
312TPDN6H0000
This is just a simple text, you cannot return min / max for text. You may only right click remove errors for the date column first, then use List. MIN. List.Min - PowerQuery M | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.