Forum Discussion
Transformation to add missing rows
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 missin...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
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.
look at this option, it's simple
Thank you. The result of the simple version does not seem to yeild the same desired result as the first.
