Trying to Link dates across sources within Power BI

[donaldowling]

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.

[HotChilli]

Sounds like you need a date table.

https://www.accountingweb.co.uk/tech/excel/power-bi-how-and-why-to-create-a-date-table

https://docs.microsoft.com/en-us/power-bi/desktop-date-tables