Forum Discussion
Solved
MIN MAX
I have seen a lot of MIN and MAX formulas out there but they do not seem to work with the data I have. I have a table called BR Overhead which holds individual value fields, such as below ...
dedelman_clng varshahrame If you really don't want to unpivot your data, you can create a measure to find the the Max Value, which I think you have done, then create a measure per column that will check to see if it's the Max Value and then use that to conditionally format the background or however you want to format it.
I've attached the PBIX as well. Hope this helps.
PaulDBrown
Community Champion
Community ChampionYou need to unpivot the table in Power Query to get the Min/Max