Forum Discussion
Pulling multiple columns from one (query, tables) into another according to multiple conditions
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
Super User
It doesn't work correctly, because the 3rd row in T2 shall match the 11th row in T1 according to the condition but it seems it's blank.
For the latest part of the condition can I write if insted of making matching betwen the two columns (Left('T1'[P02]) = 'T2'[P02]) can I write the values in the formula directly e,g: Left('T1'[P02]) = "acd" or "zip"..etc. ?
T1T2
- Ashish_Mathur
- TheoC
Community Champion
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 🙂
Thanks for your great support
- Ashish_Mathur
You are welcome. If my reply helped, please mark it as Answer.