Forum Discussion

MKPartner's avatar
MKPartner
Helper II
10 months ago
Solved

Conditional formating - comparing day to day

Hello,    I have data downloaded daily which are filtered by days in table '12week_plan'[Data]. I have a table with columns where I'd like to implement conditional formating of each row to indicate...
Need Help
  • mh2587's avatar
    mh2587
    10 months ago
    _test = // Try this might help you
VAR CurrentDate = SELECTEDVALUE('12week_plan'[Data])
VAR PrevDate =
    CALCULATE(
        MAX('12week_plan'[Data]),
        FILTER(
            ALL('12week_plan'),
            '12week_plan'[Data] < CurrentDate
        )
    )
VAR CurrentValue = CALCULATE(SUM('12week_plan'[Act_WK]))
VAR PrevValue = CALCULATE(SUM('12week_plan'[Act_WK]), '12week_plan'[Data] = PrevDate)
RETURN
SWITCH(
    TRUE(),
    CurrentValue > PrevValue, "ColoredArrowUp",
    CurrentValue < PrevValue, "ColoredArrowDown",
    "ColoredArrowRight"
)
mh2587's avatar
mh2587
Super User
10 months ago
_test = // Try this might help you
VAR CurrentDate = SELECTEDVALUE('12week_plan'[Data])
VAR PrevDate =
    CALCULATE(
        MAX('12week_plan'[Data]),
        FILTER(
            ALL('12week_plan'),
            '12week_plan'[Data] < CurrentDate
        )
    )
VAR CurrentValue = CALCULATE(SUM('12week_plan'[Act_WK]))
VAR PrevValue = CALCULATE(SUM('12week_plan'[Act_WK]), '12week_plan'[Data] = PrevDate)
RETURN
SWITCH(
    TRUE(),
    CurrentValue > PrevValue, "ColoredArrowUp",
    CurrentValue < PrevValue, "ColoredArrowDown",
    "ColoredArrowRight"
)