Forum Discussion

dsilveira's avatar
dsilveira
Advocate I
9 years ago
Solved

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

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

 

              

 

 

  • 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

1 Reply

  • 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