Transformation to add missing rows

[Excelerator]

Hi,

What are the correct transformation steps to add in missing rows per week as shown below. I need to have a row for every week of the month for every product, even if the source data is missing rows for some products (which it is). Please see below for example of before and desired after. Practical application has several hundred products spanning several years. Thanks for your assistance.

[Ahmedx]

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

[Excelerator]

Thank you. Really appreciate the direction! Looking at the applied steps, could you describe the process and what's happening? In particular, the custom step you created is complex (to my eyes). I would like to better understand so that the approach can be broken down, tweaked, and applied to other scenarios.

[Ahmedx]

look at this option, it's simple

[Excelerator]

Thank you. The result of the simple version does not seem to yeild the same desired result as the first.

[Excelerator]

Bump. Thanks.