Forum Discussion
Join tables in Power bi
Hi, Im trying to join two data tables in Power bi. Unfortunately the tables will not join as I received the error : "You cant create a relationship between these two columns because one of the co...
Anonymous , You might be trying to create a one-to-many join, that will cause an issue.
You can create a combined column using combinevalues and use that for join
Key = combinevalues("-", [Col1], [Col2])
if two are facts, then you should create dim, and do no join them
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda