Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

custom conditional formatting?

Hey guys, basically I have these three columns and I need to make conditional formatting so as that if first column value exceeds second column value, then return the difference. Otherwise, if it doe...
Need Help
Show and Tell
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi Anonymous 

    what about the following solution:

     

     

    Difference = 
VAR _Calculation = CALCULATE(
                            MIN('Table'[naujasbandymas]) - MIN('Table'[norma]), 
                            FILTER('Table', 'Table'[naujasbandymas] >= 'Table'[norma])
                    )
RETURN
    IF(_Calculation = BLANK(),TIME(0,0,0), _Calculation)

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi Anonymous 

what about the following solution:

 

 

Difference = 
VAR _Calculation = CALCULATE(
                            MIN('Table'[naujasbandymas]) - MIN('Table'[norma]), 
                            FILTER('Table', 'Table'[naujasbandymas] >= 'Table'[norma])
                    )
RETURN
    IF(_Calculation = BLANK(),TIME(0,0,0), _Calculation)

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

FrankAT You might be able to help me now. 

This is my table. First column is time in the whole number format and then second one is norm that should not be exceeded, if it exceeds this norm, then return the difference(Third column) between the two, but if it does not exceed 04:30 then return the actual time.