Forum Discussion

varshahrame's avatar
varshahrame
Frequent Visitor
5 years ago
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    ...
  • DataZoe's avatar
    DataZoe
    5 years ago

    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.

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

You need to put an aggregation on each field. If you're just looking at a single row each time, you can use SUM and it will give you the same value.

 

MAX( MAX( SUM(ColA), SUM(ColB) ), SUM(ColC) ) etc

  • varshahrame's avatar
    varshahrame
    Frequent Visitor
    5 years ago

    Yayyyy thank you so much!!!! On to my next question...from the detail below, how can i have the field that has that max value highlighted. So in this example I would like the field 'RENT" to be highlighted as thats the MAX value.

     

    I truly appreciate your help. I am so new to Power BI and I am still finding my way.