Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago

How to append with Power Query missing months to a table based on a month catalog table

Hi all   Is it possible to add to a table the missing months based from another date table catalog?   Let me explain myself better:     In the above image, I have data up to July 2020. H...
Need Help
Show and Tell
Fowmy's avatar
Fowmy
Super User
6 years ago

amitchandak 

Thanks, 

I was concerned about this part "replicating all the column values from the already existing months", |
let's see what o59393  comes back with.

o59393's avatar
o59393
Post Prodigy
6 years ago

Hi Fowmy  and amitchandak 

 

The basis should be the same for the non existing months like August 2020:

 

 

For example I sorted one SKU, plant and line. As you see they all have the share the values for mix and bpm for example. 

 

In yellow I highlighted the months that should be added hopefully with Power Query.

 

I added the values from full 2019 to the datasource if it helps in anything:

 

https://1drv.ms/u/s!ApgeWwGTKtFdhxGKCFr0n3R1vCvE?e=CFYfjH

 

Please let me know if it's clear or not.

 

Thanks.

  • o59393's avatar
    o59393
    Post Prodigy
    6 years ago

    Hi Fowmy  and amitchandak 

     

    I managed to solve it. Fortunately I did a change to one of the sources and there was no need to touch the Power Query Editor.


    Thanks!