Forum Discussion

Red_prov's avatar
Red_prov
Helper I
3 years ago

Determining availability based on existing appointments

Hello,    I have records here with a datetime stamp. For example lets say its 8:15AM. I have no end date but i have a field with an expected duration for an appointment.    However I can use the ...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi Red_prov ,

 

The information you have provided is not making the problem clear to me. Can you please explain with an example and test data?

 

Looking forward to your reply.


Best Regards,
Henry

 

Red_prov's avatar
Red_prov
Helper I
3 years ago

Hi v-henryk-mstf , 

 

 

I have the information related to who the appointment is assigned to, the start time, and expected duration. 

 

So for example say 12/8/2022 Thursday a user may have 5-10 appointments scheduled throughout the day between 8am and 8pm. They can range from 10 to 100 minutes based on the type of appointment. 

 

Looking at the start and expected end time for a persons appointments for the day. I want to calculate timeslots where they are free. So say a user has appointments scheduled from 8am-12 noon, i want to determine 12-1pm is an open slot say to take lunch. 

 

but i was wondering if i could use power BI to determine the off hours or unused time in the day .