Joining two tables off of three related columns

[timshel]

I have two tables. One is actuals and one is the budget. I want to create a matrix that shows them side by side and then a variance. I am trying to joined them into one table. I have three coulms that it needs to match in both, location, account, and department. I was also thinking of using a sumif (or something like that, since that isnt a function in Power Bi) and then putting that into a column in the budget table and then sum the actuals.

Is there any way I can do this?

 

[Cool blue]

You can create a column that combines the three columns to make a unique key and join on that. They don't have multiple joins in PBI relationships.

This way, everything will respond to filters dynamically.

 

[Matt Allington]

R

I have three coulms that it needs to match in both, location, account, and department.

Is there any way I can do this?

The way to do it is to create 3 new tables that contain the unique list of values for each column. Then join both your current tables to these 3 new tables. Then hide these 3 columns in your current tables and only use the new tables.