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

o59393 

 

I need to know, for example, if I need to add August 2020 based on existing data, on what basis should I follow? which month's data can be used and what if the month is not complete?

amitchandak's avatar
amitchandak
Super User
6 years ago

Fowmy , why do need to missing month , you use date table and join with and then add +0 in formula ?

  • 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!