Date relations on different tables

[davideromano81]

Good morning, everyone. I'm having a problem with Power BI and I can't get to the bottom of it: I have three tables that are related to each other, one with master data of some production plants and two with actual and budget data. Both the actual and budget tables have data for each month of the year and are indirectly related to each other thanks to the direct relationship with Master Data through the plant name. However, if I try to create any graph using the date taken from actual or budget, the data from the other series is not filtered by date, but is reported as the sum total of all months. Where am I going wrong?

[davideromano81]

Thank you. It works! Very helpful!

[davehus]

Thanks @davideromano81 ,

Please accept my answer if your question has been answered. 🙂 

D

[davehus · Accepted solution]

Hi @davideromano81 , You need to create a date table and link to your date columns in both tables and this should resolve this for you.