Forum Discussion

HMK's avatar
HMK
Regular Visitor
3 years ago
Solved

Pulling multiple columns from one (query, tables) into another according to multiple conditions

Hello experts, I'm trying to pull values from column "P05" & "P07" in table 2 to table 1, if the values of the following columns "P00" & "P01" in both tables are identical, and if the values of ...
Need Help
Tips and Tricks
Tutorial Requests
  • TheoC's avatar
    TheoC
    3 years ago

    Hi @HMK 

     

    I've updated the PBIX for you in the attached. I've done it all in Power Query by creating a new key and then Appending the tables into a new table.  PBIX file is attached.

     

    The appended table (new table) looks like below.  You can change / adjust as you want in Power Query, too, by just deleting whatever columns, etc, you don't want.

     

     

     

    Let me know if you need anything else ðŸ™‚

     

     

    Theo

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
3 years ago

Hi @HMK 

 

I've updated the PBIX for you in the attached. I've done it all in Power Query by creating a new key and then Appending the tables into a new table.  PBIX file is attached.

 

The appended table (new table) looks like below.  You can change / adjust as you want in Power Query, too, by just deleting whatever columns, etc, you don't want.

 

 

 

Let me know if you need anything else ðŸ™‚

 

 

Theo

  • HMK's avatar
    HMK
    Regular Visitor
    3 years ago

    Thanks for your great support