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

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You may download the revised PBI file from here.

Hope this helps.

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

HMK here is the solution you are after in the attached. Please let me know if you need anything futher mate!

 

You can follow the applied steps in Power Query and you will see the output is performed without the need for front-end / unnecessary coding which ensures a far more efficient outcome than you would otherwise experience when using DAX.

 

Do not hesitate to touch base with any other questions. 

 

Theo 🙂