Relationships between tables in which one of the table is a duplicated from the another one

[Anonymous]

Hello guys,

I have two tables, the main table is called "Ano 2019" and the other table was acheived by duplicating the main table and is called "Ano 2019 (2)". In both tables I have date columns. I have created table visualizations and a date slicer to choose the months I want to observe, but only one of the tables is filtered by the chosen month because there is no relationship between the date columns from the two tables. 

I already tried to stablish relationship between the date columns in the relationship manager, but instead of the expected result, one of the date columns loses the date hierarchy and only the data from one table is filtered. But what I wanted was a slicer to chose a month and all the data in the tables are filtered

Follows a example of what happens with my report:

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

I can reproduce your problem.

To solve this, i ceate another date table, create relationships as below and add columns from this date table as slicers.

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

[VasTg]

@Anonymous 

Create a date dimension as below and define relationship from date to other two tables. Use the month from Date dimension in slicer.

Calendar = CALENDAR(MIN(Ano 2019[DATE COLUMN]),MAX(Ano 2019[DATE COLUMN]))

If it helps,mark it as a solution

Kudos are nice too..