I trust you are keeping well and safe in these testing times.
A massive thank you to all of you who participated in Problem of the week #10.
As you will be able to testify the problem itself was on the easier side of the scale compared to some of the problems we’ve hosted in recent weeks.
Nonetheless there were some great entries across the board and some fantastic opportunities to learn from others. I definitely picked up a few things and even went down a little rabbit hole with Brian that I still don’t think I fully understood but that’s for another day.
This is a likely to be a very common pattern used in industry when end users want to specify start times and end times for particular periods.
Here is how I tackled this problem:
Step 1: Creating support table for the start time and end time. I just used the generate series function.
Step 2: A simple sum to get the total customers.
Step 3: Created a calculation considering the disconnected tables and harvest the selections into the calculation. Giving me the customers based on the date and time period selected.
Step 4: Creating a second measure but this time add the filter for weekday. Measure branched from the measure above and added a filter from the date table for weekday.
In general all entrants tackled the problem with the same high-level principles however there were some great intricacies in the implementations, and I would definitely check out the solutions posted in the forum.
Short and sweet .
Thanks all again for participating and thanks @BrianJ for hosting
See my Pbix and video below.
POW #10 HA.pbix (1.3 MB)
P.S see you all on the challenge