Dataset Comparison

[Anonymous]

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.

[CNENFRNL · Accepted solution]

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,

[Anonymous]

Smart cookie 🙂

Thank you very much!