Relationship with multiple fields on two tables

[grutkowskim]

Hello,

I'm fairly new to PowerBI and am trying to recreate a dashboard from Tableau to PowerBI. I have a budget spreadsheet with a Major Code, Date, and Budgeted sales. I also connect to our Margins data set that our actual sales flow through. In tableau, I'm able to create a relationship between both the date and major code to see performance on a monthly level. In PowerBI, I'm unable to create the two relationships. 

In the attached screenshot, I'd like to connect the Margins table to Projections Table using 

• Transaction_Date = Date
• MAJOR_CODE_DESC = Major Code Desc

Any suggestions on how to make this work?

[v-joesh-msft · Accepted solution]

Hi @grutkowskim ,

As stated in the post below:

“Composite keys are not supported in Power BI. As you suspected, you would need to create a new column in each data source that contains the combined values, then use this as the relationship column.“

Cannot create multiples column relationship between two tables

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

create a concatenated column in both tables and join on that.

Refer https://docs.microsoft.com/en-us/dax/concatenate-function-dax

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks