Trying to Link dates across sources within Power BI

donaldowling — Tue, 23 Apr 2019 22:27:04 GMT

Hi;

I have a query that I need help with.

I am designing a powerBI file and I have linked to 4 different sources i.e. excel.

I have setup the links/relationships across the files where I can e.g. UserIDs and WorkOrder Numbers.

However when I want to get data across the files to filter based on a date, selecting one of the date fields does not filter the data from the another sources for the same date.

How do I get over this. Is there a DAX command I can use. When I attempt to join the sources based off date fields it requires me to deactivate one of the other links which I can't.

Any help would be great. I can share my design file if required too.

topic Re: Trying to Link dates across sources within Power BI in DAX Commands and Tips

Trying to Link dates across sources within Power BI

Re: Trying to Link dates across sources within Power BI