Showing results for 
Search instead for 
Did you mean: 
biAiva Occasional Visitor
Occasional Visitor

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


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?

Community Support Team
Community Support Team

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

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.