Forum Discussion

AmudhaKumaran's avatar
AmudhaKumaran
Helper I
5 years ago

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. 
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

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's avatar
    AmudhaKumaran
    Helper I
    5 years ago

    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?