Forum Discussion
Solved
Max of Column in Power Query
I'm trying to get the maximum value from colum in a table on Power Query (not Power BI) and I just can't seem to be able to do it: List.Max([column]) won't work. List.Max({[column]}) returns th...
Hi benjamin_sasin ,
What type of data are you trying to get the max value ?
Sometimes you have to refer to the table before, like:
List.Max(PreviousStepName[Column])
Ricardo
Hi benjamin_sasin ,
What type of data are you trying to get the max value ?
Sometimes you have to refer to the table before, like:
List.Max(PreviousStepName[Column])
Ricardo
Okay I got it thanks.
So List.Max(#"PreviousStep"[ColumnName]) it is.
Why is this not in the List.Max function documentation? 😞
Hi benjamin_sasin ,
I'm glad it worked.
Check this link: https://docs.microsoft.com/en-us/powerquery-m/list-max
It doesn't have a lot of examples, but it's good to have an idea.
Ricardo