Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Sedos101
Helper I
Helper I

Maximum

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 PayloadNew Column For Max Payload
15053
15253
15353
26060
36061
36161
45890
48590
49090
1 ACCEPTED SOLUTION
Luis98
Resolver II
Resolver II

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:

Luis98_0-1665223942836.png

I hope this solve your question!😀

View solution in original post

2 REPLIES 2
Luis98
Resolver II
Resolver II

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:

Luis98_0-1665223942836.png

I hope this solve your question!😀

Legend @Luis98  thanks so much!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors