Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Solved! Go to 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!😀
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!😀