Log In
Register
Home
December 13, 2017
Offline
Hello, is there a kind of Max or Min function in powerquery to compare the values of different columns? I want to add a custom column which gives for each line the max value of other (existing) columns.
=> something like Max([ColumnX],[ColumnY],[ColumnZ])
See Answer
July 16, 2010
Offline
Hi Matthias,
Select the 3 columns you want to derive the max and min from > Add Column tab > Statistics > Max. Repeat for Min column.
Note: this will compare the 3 values per row and return the max/min for that row, not the max/min for the whole column.
Mynda
Answers Post
December 13, 2017
Offline
Thanks, Mynda! That helped a lot, with this info I could use List.Max exactly how I needed it.
Thanks again,
Matthias
July 16, 2010
Offline
Great! Glad it was what you were after.
New Member
February 10, 2019
Offline
Hello, is there a kind of Max or Min function in powerquery to compare the values of One columns? I want to add a custom column which gives for each line the max value of other (existing) columns.
=> something like Max([ColumnX])
New Member
March 18, 2020
Offline
Hi there,
Is there a way to do the same with Dates? When I tried the above with Dates, the Min/Max is greyed out (unavailable).
I want to find the Min and Max per position number in Power Query for the following example:
Position # Begin Date End Date Min Date Max Date
12345 1/10/10 1/10/13 1/10/10 31/12/99
12345 2/10/13 2/10/15 1/10/10 31/12/99
12345 3/10/15 31/12/99 1/10/10 31/12/99
67890 1/3/16 1/4/18 1/3/16 31/12/99
67890 2/4/18 1/4/19 1/3/16 31/12/99
67890 2/4/19 31/12/99 1/3/16 31/12/99
Look forward to hearing from you.
🙂
1 Guest(s)
