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
BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

I'm unable to recreate your issue as I understand it.

 

Could you let me know exactly what you are trying to achieve with this function e.g. are you trying to turn the whole table into a single number, or want to use this max value as a variable somewhere else etc.

 

Please also share your M code for this query.

 

Pete