Calculation not happening correctly for some data

Hi v-sihou-msft,

I updated my measure for updated_qty.

However can you help me create a new measure for more meaningful data for Updated_Quantity using DAX.

In this i need to assign the previous week's cumulative value (which is stored in the updated_qty field) to the next week "On Hand" order_type and it should remain same for other order types.

Please help me in performing this as it is very urgent!!

There is one more requirement as well.

We need to roll up the data across different weeks like the way illustrated in the screenshot.

If the data is not existing across any week it should retain the data of previous week.

in the example above the week 2017-52 is having quantity as -2 0 0 ,

so it should be replicated to all the subsequent weeks till the end. from 2017-53 to 2018-11)