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

3 Replies

  • 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.