Forum Discussion
DAX expression to calculate sums per date
You will need to re-work the model so that actual and scheduled can be connected on date and machine ID.
One simple way of doing this would be to merge the two queries in Power Query (on Date and machine).
This will give you one table with all the right data.
If you want to slice and dice by date or do more complex date-related operations, create a date table in the model and add a relationship to the new single table.
Community ChampionYou will need to re-work the model so that actual and scheduled can be connected on date and machine ID.
One simple way of doing this would be to merge the two queries in Power Query (on Date and machine).
This will give you one table with all the right data.
If you want to slice and dice by date or do more complex date-related operations, create a date table in the model and add a relationship to the new single table.