Adding missing calendar month rows to table

[BobbyDollar]

Hi

I have have a data table with sales results of Region, Product, Date (only monthly needed) and a Quantity.

I would like to automatically add rows for all Region/Products where the month is missing with Quantity 0. E.g. from DACH and Product M I am missing June as well as Aug - March, so it should add 9 lines with DACH, Product M, missing and so on for the other region/products.

As a result:

Reason is that I want to add a calculated column for the forecast later on, and this might add quantities to the missing month. If I do not have all 12 month line I am missing numbers.

I know ... does not sound very professional but i do not know better yet, being under time pressure.

Instead of the month I have a calendar date as well, connected to a date table ...

Any feedback appreciated
Thank you

Robert

[serpiva64 · Accepted solution]

Hi,

You can achieve this

starting from this 

by applying the steps of the attached file

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!