Cumulative week wise data to week wise

Power Query
1

I have cumulative distribution at week level.

I want convert cumulative values to week wise values.

Excel file attached with dump data and final required transformation.

CUMULATIVE TO WEEKWISE.xlsx (12.5 KB)

Thanks in advance

2

Hello @prafullchavan1,

Thank You for posting your query onto the Forum.

Is this the type of results you’re looking for? Below is the screenshot provided for the reference -

Final Results
Final Results1257×935 38 KB

I’m also attaching the working of the PBIX file so that you can go through the Power Query steps alongwith the link of the video provided for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

Weekly Values - Harsh.pbix (18.4 KB)

2 Likes
3

Thank You very much