Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
What's the trick here? Please help.
Solved! Go to Solution.
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