M code - List.Min

[AmudhaKumaran]

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]

@AmudhaKumaran 

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.

[selimovd]

Hello @AmudhaKumaran ,

check if your column is in the format Text.

If that is the case change it to a Number format in the step before.

Or you could also solve that in M:

List.Min(Number.FromText([myColum]))

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍 

Best regards
Denis

Blog: WhatTheFact.bi

[AmudhaKumaran]

Hi Denis,

Thanks for your reply. I have that column in Date format. While I tried to keep error in that column, I'm getting below. 

DataFormat.Error: We couldn't convert to Number.
Details:
312TPDN6H0000

Any clue?