Forum Discussion
Conditional Formatting
Little Help here, Im using one Measure in a matrix table (CRR = Retention %) and looking at the 2022 CRR and 2021 CRR with Year in the column portion of my table. I want to use conditional formatting...
Anonymous Logic wise I would try something like:
Color Measure =
VAR _CurrentYear = YEAR(TODAY())
VAR _CYmeasure = [Measure]
VAR _PYmeasure = [PYmeasure] -- CALCULATE( [Measure] , DATEADD(Date[Date], -1, YEAR) )
RETURN
IF( YEAR( Date[Date] ) = _CurrentYear,
IF ( _CYmeasure > _PYmeasure, "Green", "Red")
)
Anonymous Logic wise I would try something like:
Color Measure =
VAR _CurrentYear = YEAR(TODAY())
VAR _CYmeasure = [Measure]
VAR _PYmeasure = [PYmeasure] -- CALCULATE( [Measure] , DATEADD(Date[Date], -1, YEAR) )
RETURN
IF( YEAR( Date[Date] ) = _CurrentYear,
IF ( _CYmeasure > _PYmeasure, "Green", "Red")
)