2fact table with multiple dates and one date table

[Seethag]

I have 2fact table and each of which table having open and close date and created one date dimension table.

Already made one active and passive relationship between date table to fact table 1

Do I need to create same relationship from date to fact table 2?

If created it is not displayed date in visual

So can you suggest me alternate method

[aj1973]

Hi @Seethag 

It depends on what you need to get from Table 2, but yes you can connect Date table to it or add a new Date Table and connect it to Table 2. It all depends on your needs