Forum Discussion

davideromano81's avatar
davideromano81
New Member
4 years ago
Solved

Date relations on different tables

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?

 

  • 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.

3 Replies