Class Schedule with Random Start times

[ipon70]

Hello,

I am trying to make a class scheduler. 

Here is what I have already cleaned up and imported.

The class list with length of class, the day and times everyone works.

I have working the "class picker" and "date to schedule".  What isn't working is the time frame for the student.

Lets say a worker shows up for work at 10:00am and works until 6:30pm.

I want to schedule a class at 2:00pm that will end at 4:30pm.

That person is here for that entire time frame, but because his start time is 10:00am the slicer doesn't know to include him.

In excel I could see a "IF(AND(worker start time <= class start time, worker end time<=class end time),"YES","NO"))  But in PowerBi I am struggling.

I believe I need something like Class start time + the Length of the class = X

then

X is <= Workers End Time

I hope that made sense.

I am working on Version: 2.100.1401.0 64-bit (December 2021) of the desktop software.

[v-shex-msft · Accepted solution]

HI @ipon70,

It sounds like a date range defined by multiple fields analysis requirement. I'd like to suggest you take a look at the following blog start end date part if it helps for your scenario.

Before You Post, Read This: start, end date 
Regards,

Xiaoxin Sheng