Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |