Forum Discussion

PatrickByGecko's avatar
6 years ago
Solved

Conditionnal Formating with pure field

Hello I'm trying to have conditionnal Color formating on a simple numeric Field (here underneath CodeProjectID) but the menu panel always propose to have condition on the number of CodeProjectID not...
  • edhans's avatar
    edhans
    6 years ago

    Use MAX for this. MAX will return the max value, but both MIN and MAX have a unique characteristic where they will convert a field to a scalar value if there is only one value in your field.

     

    So MAX(Table[CodeProjectID]) will work