Forum Discussion
DAX expression to calculate sums per date
Hi all, I am trying to create a table within a report that shows the actual hours and scheduled hours for a list of machines. The actual hours and list of machines are in one table and I have connec...
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.
HotChilli
Community Champion
Community ChampionSounds good. Do that before the merge.
Use 'Group By' on the Home ribbon. Choose 'Advanced' so you can group by machine AND date.
That did the trick, thanks!