Forum Discussion
Solved
Conditional Format on date change
Hi is it possible to conditional format a matrix if a number has changed between dates. I have two dates that i am comparing the ordered date and the order due date. I want to format if the total ord...
Change Color =
VAR _current = [Order Count]
VAR _prev =
CALCULATE(
[Order Count],
PREVIOUS('DueDate'[Order Due Date])
)
RETURN
IF(_current <> _prev && NOT ISBLANK(_prev), "#FFFF00", "#FFFFFF")Set the matrix cell background to Field Value using this measure.
Change Color =
VAR _current = [Order Count]
VAR _prev =
CALCULATE(
[Order Count],
PREVIOUS('DueDate'[Order Due Date])
)
RETURN
IF(_current <> _prev && NOT ISBLANK(_prev), "#FFFF00", "#FFFFFF")
Set the matrix cell background to Field Value using this measure.