Forum Discussion

arendmario's avatar
arendmario
Copper Contributor
Dec 17, 2018
Solved

Structure Data as Time Series- Power Query

Hello, I am new in Power Query and I want to structure the following original data as a time series structure (I need to leave the values that do not have information in blank).   Original data ...
BI & Data Analytics
tips and tricks
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 17, 2018

    Hi,

     

    You may pivot on names - value first table and merge it with second one using right outer join.

    I assume months are defined in same way for both tables, here are as first date of each month - please see attached

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 17, 2018

Hi,

 

You may pivot on names - value first table and merge it with second one using right outer join.

I assume months are defined in same way for both tables, here are as first date of each month - please see attached

Resources