Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Add Column from other table

Hi good day,  Can anyone pls need assiatance on my table below, i want the data on Table 01 (Prodtime&NonProd) to reflect on my table 02 Thank you
  • Ritaf1983's avatar
    1 year ago

    Hi AllanBerces 
    You can merge them in a power query by 2 key fields:

    Result :

    If you don't need a first table in a model you can disable the option to load it :

    The pbix is attached you can follow my steps

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