Forum Discussion
Solved
Pull values from 2 tables into a 3rd table
I'm new to Power BI. I'm trying to create a 3rd table that takes columns from the first 2 tables so I can add some additional calculations on those "joined" values. Maybe there's a better way....But ...
Hi Nathan,
I was actually able to accomplish this using the "Merge Queries" - now I have a table that contains values from both tables. Thank you for your help!
Hi saturation ,
Starting from scratch, Summarize might be better. Modeling tab Select New Table then added a total column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Table3 = SUMMARIZE(Table1,Table1[Cost],Table2[NUMOFUNITS] )
Hi Nathan,
I was actually able to accomplish this using the "Merge Queries" - now I have a table that contains values from both tables. Thank you for your help!