Relationship between two columns (with the same value) in different tables

[dsilveira]

Hi, 

I'm trying to works with differents columns in the same time. For example:

I have table user:

Name     Created

Peter     '07/05/2016'

Sam       '07/09/2016'

And in table worker I have

Name      Created

Jimmy     '07/23/2016'

Andrew   '06/21/2016'

In my Power BI Desktop I can work with each table independently, BUT I would like to do a Slicer filter by Created in the same time, that is to say, if I select month 7, I should show (for each grid independently of each table) the user and workers Created in this month... Something like this

              

[BhaveshPatel · Accepted solution]

Hi there,

You need to create a data table and create relationships between date table and user & date table and Workers.

Once this is in place, You can slice and dice your data as per your needs. Make sure that Slicer field comes from the date table.

Thanks & Regards,

Bhavesh