Forum Discussion
Solved
Can´t create a relationship between two columns because one of the columns must have unique value
Hi In Desktop Power BI, I have made a report, with 3 excel files, and want to make a link between these excel files, In file A: I have the "poduct number", and lots of other product informat...
KSveigaard basically what that error is complaining about is that relationship you're trying to create from column within 'FROM' table to your column in 'TO' table has issue. one of that column must have unique product numbers. you can't have Many to Many relation but only One to Many or Many to One relation. So ensure that one of the table has unique product numbers and then there won't be any issue.
rusgesig
Helper IV
Helper IVDon't include columns that aggregate in your summary table, add custom columns afterwards and do the calculation in them.