cumulative sum of values for a week

[Saaharjit]

I have the below table

I want to display bar graph that has the cumulative sum of Panels for a week. Then after the week it refreshes starts again for the next week. We are using Date completed column to figure out the week.

For eg.

week 1:

1st nov - 10 panels are produced 

2nd nov - 10 panels are produced (the bar graph would have 20 panels for 2nd nov)

3rd nov - 10 panels are produced (the bar graph would have 30 panels for 3rd nov)

...

Example for the graph

[Zubair_Muhammad · Accepted solution]

Hi @Saaharjit

Try adding this Calculated Column

Cumulative_Panels =
SUMX (
    FILTER (
        TableName,
        WEEKNUM ( TableName[Date_Completed] )
            = WEEKNUM ( EARLIER ( TableName[Date_Completed] ) )
            && TableName[Date_Completed] <= EARLIER ( TableName[Date_Completed] )
    ),
    TableName[Panels]
)