Find a value in different tables by date

[Syndicate_Admin]

Hello, I would like to know if it is possible to look for a value X in different tables, according to the date on which that value X occurs, considering that the identification number of that value X, could be in different tables at the same time. When I try to create relationships between the main table that contains the X value and the other tables it tells me that there are duplicate values so it is not possible.

Any idea of how to fix it or if it is possible to do it? THANK YOU!!

[Syndicate_Admin]

Thank you very much, I will do the tests and comment. Best regards

[v-easonf-msft · Accepted solution]

Hi, @Syndicate_Admin 

It is recommended to create two separated dimension tables based on the field 'Date' and the field 'Value' of table1.

Then try the following relationship model to filter the data in other tables.

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason