Adding value from previous week to next week

Hi mr_oli ,

Could you try this formula:

Cumulative Value =

CALCULATE(

     SUM(Sheet1[Value]),

     ALLEXCEPT(Sheet1,Sheet1[Product],Sheet1[Location]),

     Sheet1[Week]<=EARLIER(Sheet1[Week])

)

 

 

Cheers,

Nemanja

 

Hi, mr_oli 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

You may create a measure as below.

Result = 
CALCULATE(
        SUM('Table'[Value]),
        FILTER(
            ALL('Table'),
            'Table'[Product]=SELECTEDVALUE('Table'[Product])&&
            'Table'[Location]=SELECTEDVALUE('Table'[Location])&&
            'Table'[Week]<=SELECTEDVALUE('Table'[Week])
        )
)

Result:

Best Regards

Allan

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