Forum Discussion
AS > Tabular Model > How to set multiple relationships between 2 tables?
Community ChampionYou can create a duplicate table as suggested, but you can also create an inactive relationship. I have covered both and the merits of each in this article here: http://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
Resolver IHello Daxesh,
I have validated and in this case you can go ahead and create multiple calendar tables. Marking as a Date table is required in excel while adding a TImeline control. But for Power BI this seems working fine.
Hence, you can have Calendar table 1 to map with Date1 & Calendar table 2 to map with Date2. Once the maping is done, you can use Calendar table 1 in the timeline in view one to filter your data on Date1 of fact table & use Calendar table 2 for the another view in the same manner.
Hope, this helps!