Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |