Skip to main content

Power BI

New

Power BI table relationships

Vote (13) Share
priyanka's profile image

priyanka on 14 Nov 2017 16:49:49

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.

Comments (1)
priyanka's profile image Profile Picture

c4439f19 9722-4e45-8a19-dd324f9f5dd4 on 05 Jul 2020 23:04:31

RE: Power BI table relationships

This is a major point of frustration for me. Too often I would need to join on 3 or four columns, adding new columns as a workaround is just frustrating and unnecessary. Also, I don't want them in the same table, so merging the tables in the query editor is useless.