Dimension duplicatd to users table with transaction table with user in two different columns

[Laocsulak]

Hello,

I have a transactions table with buyers and sellers, I would like to ask what's the best way to model this to show information about them with a users table where I have the complete information of the users, for example the name.

I created this dummy model where I show this problem:

I had duplicated the users table to able to relate the sellers in one table and the buyers in the another table because I have two different columns in transaction table for them. Is there a better way to do this without duplicating the users table?

Power Bi and Excel Files: 

https://drive.google.com/drive/folders/1C9CnodQAWsk8O1yTCEhtAMXBiJVL1kjf?usp=share_link

Thanks in advance!

[amitchandak]

@Laocsulak , can use single join and userelationship for inactive join. But that means you can filter same value for both buyer and seller.

So I feel your model is right

Other option

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...