Forum Discussion
Relationship with multiple fields on two tables
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?
Hi Anonymous ,
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.
2 Replies
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.
ThanksHi Anonymous ,
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.
