Forum Discussion
Create relationships using 2 columns as primary key
Please allow us to create relationship between two tables using a combination of 2 columns instead of single column, if none of the single columns have unique values. Sometimes it is not possible to create summary tables with unique values for any column.
4 Replies
You could create a column concatenating the two you want to use as a workaround?
That won't help in my case, since I am making a generic template and the base table would be deleted and readded every time. I would like to minimise the effort as much as possible.
We can either creating another summary table or using a concatenated column in such scenario.
Please also create an idea in https://ideas.powerbi.com for feature request.
Best Regards,
HerbertThanks. I did that.
