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 

    That would actually be my ideal solution, however i get the following error : 

     

    • FrankAT's avatar
      FrankAT
      Community Champion
      5 years ago

      Hi Anonymous 

      the MIN() function doesn't accept a measure as an argument. If [naujasbandymas] is a measure my formula fails.

      How does your measures and tables look like?

       

      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

        Yes, i managed to change it from the measure to actual variable and it works perfectly now, many many thanks. 

  • 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.