Forum Discussion

mgost's avatar
mgost
Frequent Visitor
1 year ago

Multiple relationships between 2 tables

Hi everyone,   I really need your help. I am stuck. I need to calculate Amount by User in Document Number, but user can occur in any of three columns - First User, Second User or Third user. I can...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mgost ,

 

I'm assuming the data in the Delivery Order table looks like this:

If so, select the three User columns, right click and click the unpivot columns:

Then filter out Blank.

Relationship:

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • mgost's avatar
    mgost
    Frequent Visitor
    1 year ago

    Thank you for your reply, but I would also use unpivot to manage these 3 columns-that is my backup solution. The problem is that my Delivery Order table using unpivot is growing in size. I want to keep it as it is, because data model is already big. Is there any way to use three relationships on delivery order from users? i tried with 2 inactive realtionships and of course, and with USERELATIONSHIP but it gives error because it is then ambigous relationship...