Max() value of entire column

[mdrammeh]

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:

[Sean]

@mdrammeh

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)

http://community.powerbi.com/t5/Desktop/baddest-Month-of-each-Year-based-on-value/td-p/42024

Full credit goes to @KHorseman

Good Luck!