Forum Discussion
AdministratorFind a value in different tables by date
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!!
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
2 Replies
- v-easonf-msft
Community Support
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 
Syndicate_AdminThank you very much, I will do the tests and comment. Best regards