relationship between table

[MP_123]

hi, i have 2 tables as below:

date              window dim dim dim

1-1-2016          1         X       y     z

2-1-2016          28         X       y     z

date              window dim dim 

1-1-2016          1         X       y     

2-1-2016          7        X       y    

the schema of the two tables are similar but not the same

i have another mapping table (one to mant with the two tables above)

window      title

1                daily

7                weekly

28              monthly

and i have another table of the time dimension (one to many with the two tables above)

i want to have two slicers: date and 'title'

the problem is that: i want that if i select 'daily', dates will be filtered with only daily date (from the two tables)

and if i filter date, it should affect both tables

how can i do it?? i wanted to create combined table with date and window, but power bi doesn't support manyt to many relationship

thanks!

[CheenuSing]

Hi @MP_123

Could you please share some data and the output you expect.

Cheers

CheenuSing

[MP_123]

hi@CheenuSing

attached my releationship

i want to create two slicers: time and date (yellow) and i want it to affect each other:

for example if i select time = 'Weekly' so the dates from Time table will filter (and the other tables also) and if I select date, also all tables will be filter

bottom line: i want to have relationship between all tables

the problem is that if i'm combining all dates from the two fact tables, it's many to many relationship

thanks!

[CheenuSing]

Hi @MP_123

Please post some data of each table or put it in one drive and share the link.

Cheers

CheenuSing