Date filter on historical related tables (many-to-many relationship)

[biAiva]

Hi,

I'm trying to use the many-to-many relationship  to relate two historical tables: Accounts and InvestmentsDetails linked by AccountId. 

Both tables has duplicated values, because there is one registry for each date in the Accounts table and many registries for each date, each account and each investment option in the InvestmentDetails table . 

I though I would be able to link both tables by the AccountId column and also to the Date table in order to filter both tables for a selected date, but it is no possible to mantain both relationships active, so I can't solve the problem this way... any suggestions?

[v-yulgu-msft]

Hi @biAiva ,

As you know, only one relationship between two tables can be set to active. However, you could use USERELATIONSHIP function to specify the inactive relationship when applying filters via measure.

Best regards,

Yuliana Gu