Forum Discussion
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...
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)
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)
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)Yes, i managed to change it from the measure to actual variable and it works perfectly now, many many thanks.