Forum Discussion
Dataset Comparison
Hello,
I have datasets similar to the below.
Dataset 1 - Timesheet Booking Data
| Date | Hours |
| 01/02/2022 | 11 |
| 02/02/2022 | 42 |
| 03/02/2022 | 53 |
| 04/02/2022 | 32 |
| 05/02/2022 | 14 |
| 06/02/2022 | 66 |
| 07/02/2022 | 55 |
| 08/02/2022 | 77 |
Dataset 2 - Timesheet Weekly Summary
| Week Ending Date | Hours Summary |
| 03/02/2022 | 140 |
| 10/02/2022 | 220 |
I am trying to compare dataset 1 & 2 to make sure the hours booked during the week match the hours summary dataset.
Work weeks run from Friday - Thursday. Therefore week ending date 03/02/2022 would be a summary of hours between dates 28/01/2022 - 03/02/2022.
Dataset 2 - Timesheet Weekly Summary shows a summary of all hours booked during that week corrisponding to a week ending date.
DAX Measured needed
1. SUM of of all hours per working week in dataset 1
I can then compare this sum of hours per week along side my Dataset 2 - Timesheet Weekly Summary figure.
Simple enough since the Week Ending Date column is available,
For fun only, a showcase of powerful List.PositionOf(),
Another showcase of powerful Excel worksheet formula,
2 Replies
Simple enough since the Week Ending Date column is available,
For fun only, a showcase of powerful List.PositionOf(),
Another showcase of powerful Excel worksheet formula,