Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
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,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Smart cookie 🙂
Thank you very much!
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |