Forum Discussion
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
- BhaveshPatelSuper User
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