Hi, there, I am looking for help & guidance to solve this problem. At the same time, also looking for training materials recommendation around this topic as I find my understanding around this time measure/slice context is pretty weak.

Currently I have a report to show current selected shift vs previous shift (Sam helped me with this too).

This has been working out great.

Now I need to throw in a new requirement to compute “Remaining Patients” and also to see the numbers break down between Nurse & Phlebotomist, for some reason, the calculated #s are same for all categories. This compute relies on Ord-date & ord-time (ord = order)

based on the current vs prior shift logic that recommended by Sam, I think the only way to fix this problem is to model the data to have the capability to slice based on ord-date. Currently the shift information is generated based on Coll-Date & time (collection date)

Hence to fix this, I would need to

1- rename CollectDetails[ShiftSelection] to be CollectDetails[coll-shiftSelection]

2- Add a new column CollectDetails[ord-shiftSelection] - where the shiftSelection data is generated from ord-date & time information.

Am I on the right track ?

PBIX is here. PAS-New- AccessNumber attempt - added open orders compute.pbix (1.1 MB)