Relation in Power BI Desktop RS

[Anonymous]

Friend,

i have two table (Booking table and Guest table) using in Power Bi Desktop RS, how can i relate these two table (id column have many repeated data in both tables)

Power BI Desktop RS do not support many to many relationship.

i would like to have one to many relation or any other solution

Booking Table:
id	Book by	BHK Type	Occuapancy
100	A	1BHK	3
100	A	2BHK	3
101	B	2BHK	2
102	C	1BHK	2
103	D	2BHK	2
103	D	2BHK	3

Guest Table:
id	Book by	Book For
100	A	A
100	A	Y
100	A	Z
101	B	P
101	B	B
102	C	C
102	C	H
103	D	M
103	D	N
103	D	O
103	D	L
103	D	K

Thanks

jia

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[amitchandak]

@Anonymous , One of the way is to create a common dimension table. but that depends on what solution you want

refer : https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda