Forum Discussion
Anonymous
8 years agoNot applicable
Creating Relationships between Date Columns - 2 Data Tables and a Common Table for filtering
Hi Hoping someone can help as this has been bugging me for hours on end now. I have two tables, one with Orders and one with Quotes. Both tables have a date column for there estimated close d...
v-yulgu-msft
8 years agoMicrosoft Employee
Hi Anonymous,
When you add data fields from two tables into two separate table visuals, you can use a slicer date slicer from 'CommonTable' to filter both visuals. It works. But, if you want to combine data from two tables into a single visual, you should drag the date from commontable into table visual rather than date fields from source table.
Regards,
Yuliana Gu
Anonymous
7 years agoNot applicable
Hi, any solution about this? I have the same problem.