Forum Discussion
Cuscino
8 years agoFrequent Visitor
Unique column values
Hi
I ve been trying to create a relationship between two/more column
Since I have 12000 raws, I had to eliminate the duplicates in Excel (Product ID Workbook)
I ve checked and doubled cheked and there aren´t any duplictes but I m still having the same messages error in power bi
" You can´t create a relationship between these two colum..."
Could u help me? Could be a bug?
Thanks
Have you tried using the Trim function on your column? There may be trailing whitespace that is causing an issue.
2 Replies
- jcarvilleSkilled Sharer
Have you tried using the Trim function on your column? There may be trailing whitespace that is causing an issue.
- AnonymousNot applicable
Check you have no blank lines