Forum Discussion

Corentin_bodros's avatar
Corentin_bodros
New Member
4 years ago
Solved

Power query merge data with different level of granularity

Hello,    I have two data set wich I'd like to compare, my budgeted costs against effective cost in the PnL.  Problem being in the budget which is made by different persons, we can find data infor...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Corentin_bodros ,

     

    You could merge tables with more than one matching fields or create a new index that contains all the granularities to merge.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.