Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Error: We Cannot Convert a value of Type List to Type Text

Hi, I have an int column in my table that I am tryng to obtain the max of.    I am using = List.Max(#"Added Custom1"[Count]) to obtain the max value, however I receive the following error.  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi v-jingzhang,

Thank you for your reply. 
Unfortunately, the step 

= Table.AddColumn(#"Changed Type", "Max Value", each List.Max(#"Changed Type"[Count]))

produces the following

Error: We Cannot Convert a value of Type List to Type Text

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

Are you able to use the User Interface to get the maximum value of Count column? Go to Transform > Statistics > Maximum.

 

Jing

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This produces the exact same error message