Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Max() value of entire column

I have a dataset in Power Query that looks like the screenshot attached. I want the MAX column to return the Maximum value from the “TOTAL DESIGN” column and copy it all the way down the “MAX” column.  

Next, I want “BEST Month” column to return where the “Total Design” matches “MAX” total and call it “BEST YEAR”. And if the “BEST YEAR” Column matches “MAX” column, then rerun as “2nd BEST YEAR”. In Excel expression it’s something similar to this:


Design total.PNGMAX Value Question.PNG

Community Champion
Community Champion

Re: Max() value of entire column



Here you go - I believe you'll find the answer you are looking for here - you may have to read all posts

(I think it was the 2nd one marked as answer, its not the 1st because that one uses a rank table)


Full credit goes to @KHorseman Smiley Happy


Good Luck! Smiley Happy

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors