Forum Discussion
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. ...
Hi Anonymous
You can add a custom column to have the maximum value in Count column.
= Table.AddColumn(#"Changed Type", "Max Value", each List.Max(#"Changed Type"[Count]))
Then filter Count column by comparing its value with the value in Max Value column.
= Table.SelectRows(#"Added Custom", each [Count] = [Max Value])
After that, you can remove the Max Value column.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
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