Cumulative weeks

[LD1]

Hi everyone, 

I just want to figure it out how to cumulate the sum of Turnover by weeks please?

In other word, I would like to create this graph :

x = Weeks by one year

y = Turnover

But, what is the formula to create this cumulating turnover? 

Start date : it depend on the selection "Date" in the timeline

End date : Like below, it depend on the timeline

Here is the graph :

Thank you a lot for your answer and have a good day !

Lena

[LD1]

Thank you a lot @joaoribeiro !

[joaoribeiro · Accepted solution]

Hi @LD1 ,

For this you can check what are your first and last dates for each data point and then calculate the measure in the 'datesbetween'. Please check an example below that I created based on your scenario:

Cumulative Value = 
VAR _min_date = CALCULATE(MIN('Table Name'[Date]), REMOVEFILTERS('Table Name'[Week]))
VAR _last_date = MAX('Table Name'[Date])

RETURN
CALCULATE(
    SUM('Table Name'[Value]),
    DATESBETWEEN('Table Name'[Date], _min_date, _last_date),
    REMOVEFILTERS('Table Name'[Week])
)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

Thanks!

Best regards,
Joao Ribeiro