Forum Discussion
MP_123
9 years agoMicrosoft Employee
relationship between table
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 d...
MP_123
9 years agoMicrosoft Employee
hiAnonymous
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!
Anonymous
9 years agoNot applicable
Hi MP_123
Please post some data of each table or put it in one drive and share the link.
Cheers
CheenuSing