Urgent Help! Creating a line graph to show running total of target value by week ending date

[emphx1]

Hi guys! I am new to this community and will be my first post, please let me know if I am following all rules and hopeefully this post is petty clear! 

Long story short I am fairly new to DAX all self taught, I am trying to created a line graph that shows acrtual values over time by week endign date (No issue here) compared to a target value of what is needed to be obtained every week to maintain schedule by a hard end date. 

Example - In order to compelte this stint of the project we need to be able to earn a total of X units per week which I have caculated. I would like to show this on a line graph compared to actuals and see where we line up. 

See atatched snip of how this currently looks. Id like this to show out to the end date of 10/2/24 along with a running total of weekly targets by week ending date from start of project to end target date. 

Any help or tips wopuld be much apprecaited! 

[Anonymous · Accepted solution]

Hi @emphx1 ,

Maybe you can try formula like below to create measure:

Cumulative_Actual = 
CALCULATE(
    SUM('ActualTable'[ActualValue]),
    FILTER(
        ALL('DateTable'),
        'DateTable'[Date] <= MAX('DateTable'[Date])
    )
)

Cumulative_Target = 
CALCULATE(
    SUM('TargetTable'[TargetValue]),
    FILTER(
        ALL('DateTable'),
        'DateTable'[Date] <= MAX('DateTable'[Date])
    )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

Welcome to the forum.

Here's how to ask your question:
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Qu... 

[emphx1]

Adding a bit of clarity here, when I add the tharget value to the graph it is being shown as a flat line rather than a running total starting from 0 as show below.