Forum Discussion
Solved
Relationship Issue
Hello, im having a problem with a report that was created beforehand, the main issue is in the following two tables we have : Journals, Structure. Journals is the fact table we're getting f...
hello Hussein_charif
as mentioned by rohit1991 , the problem with many-to-many is power bi can not tell which to which when you have repeating id.
sharing my experience for many-to-many relationship in my previous project, i created a calculated column in both table for "dummy" unique id which come from concatenate two column.
this way is better than having relationship only from one column which has repeating id.
Hope this will help.
Thank you.
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you