How to stop showing 'cumulative actual' line values for future weeks.

[Mattpar]

Hi,

Below is my problem.. and thanks in advance for any solutions!

Line's below represent cumulative budget vs actual figures for year-week.

I am showing future 4 weeks budget forecast in the graph (red line) but I do not want to see a flat cumulative actual (blue) line for the future weeks. Since this is a weekly updated graph I am looking into a moving solution not just a running total up to 2020-31. Also to note my year-week values are stored as text.

Currently my runnning total measure is like below. It starts from week 2020-19 and goes up to max week number.

Cumulative Actual = CALCULATE([Actual Spent],FILTER('Combined'[Year-Week] >= "2020-19" && 'Combined'[Year-Week] <= MAX('Combined'[Year-Week])))

[v-yiruan-msft · Accepted solution]

Hi @Mattpar ,

Please update the formula of your measure "Cumulative Actual" as below and check whether it can get your desired result:

Cumulative Actual =
VAR _CumActual =
    CALCULATE (
        [Actual Spent],
        FILTER (
            'Combined',
            'Combined'[Year-Week] >= "2020-19"
                && 'Combined'[Year-Week] <= MAX ( 'Combined'[Year-Week] )
        )
    )
RETURN
    IF ( NOT ( ISBLANK ( [Actual Spent] ) ), _CumActual, BLANK () )

Best Regards

Rena

[Mattpar]

@v-yiruan-msft That is all I needed. Works perfectly!