Conditional formating - comparing day to day

[MKPartner]

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 changes of value like decreased, increaased or it's equal against previous day. 

I'm using below DAX to get it: 

CF_Act_WK = 

    VAR ACT_DAY = CALCULATE('12week_plan'[Act_WK],
                                FILTER('12week_plan','12week_plan'[Data]))
    VAR PREV_DAY = CALCULATE('12week_plan'[Act_WK],
                                FILTER('12week_plan','12week_plan'[Data]-1))

RETURN
SWITCH(True(),
                    ACT_DAY - PREV_DAY < 0,"ColoredArrowDown",
                    ACT_DAY - PREV_DAY = 0,"ColoredArrowRight",
                                        "ColoredArrowUP")

My issue is that when I changing dates filter, I can always see "ColoredArrowRight" mark evan values are decreasing or increasing. 

Thanks for support. 

[mh2587 · Accepted solution]

_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"
)