Relationship multiple columns between two tables

[spycein]

Hi Everyone,
I have two tables, One is Budget Table and another is Expense Table.

In both the tables there are two columns which are common.

One is "Quarter" and another is "Budget" Column.

I want to create relationship between both the tables and create a Power BI dashboard with these two filters. i.e. "Quarter" and "Budget".

Thanks

Shib

 

[Matt Allington]

I wrote an article that should help you. Multiple Data Tables in Power Pivot - Excelerator BI

bottom line, you need to create 2 new lookup tables, 1 for budget, one for quarter, then join both of your current tables to both lookup tables