Forum Discussion
Solved
How to get max value from different columns
Hi everyone, I have a question regarding m language. I have this table: I need to find the max number of records regarding those 3 columns (Person, Unit and Location), so what I did...
Hi,
to obtain this (in my case 9 is maximum)
You need to add a custom column
List.Max({[Column1], [Column2], [Column3]})
then List.MAx on your added column
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
serpiva64 already gave the answer to the question.
Just adding the photo to achieve the same requirement.
Thank you.
Hi,
to obtain this (in my case 9 is maximum)
You need to add a custom column
List.Max({[Column1], [Column2], [Column3]})
then List.MAx on your added column
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
