Forum Discussion
Hussein_charif
Helper V
Helper VRelationship 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.
Hi Hussein_charif
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.