Maximum

[Sedos101]

Hi Everyone

I have the following dilemma and would like to know how to add a new column using Power Query to get the desired result

Basically I have a table with the first two columns however I need another column to populate the maximum payload recorded for a cycle number as can be seen below:

Can someone please help me on how to write this in Power Query?

Thank you

Cycle Number	Payload	New Column For Max Payload
1	50	53
1	52	53
1	53	53
2	60	60
3	60	61
3	61	61
4	58	90
4	85	90
4	90	90

[Luis98 · Accepted solution]

Hi @Sedos101!

I would do the next:

First duplicate the table and group the new table by Cycle number with Max Payload, the formula would be something like this:

#"Grouped Rows" = Table.Group(#"Changed Type", {"Cycle Number"}, {{"Count", each List.Max([Payload]), type nullable number}})

 Then merge the first table with the new table by cycle number, and you would get this:

I hope this solve your question!😀

[Sedos101]

Legend @Luis98  thanks so much!