Forum Discussion
Class Scheduler
I am trying to develop a training class scheduler. I have start and stop times for all empoyees shifts. There are 54 different shifts. My goal is to select a class time and duration and have only officers that will be available for the full class listed.
1 Reply
Ashcraftbobbi , Create an independent Time table(Class Start Time) and duration table using generateseries (say in minutes)
Then you can have a measure like
Countrows(filter(Table, [Shift Start Time] <= selectedvalue([Class Start Time]) &&
[Shift End Time] >= (selectedvalue([Class Start Time]) +time(0, selectedvalue(duration[Value]),0 ))
))Time Table
https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucketsPower BI, DAX Generateseries: https://youtu.be/VBGUGZMy8FI
Learn Power BI: Calculatetable, Summarize, Groupby, SummarizeColumns, Except, Distinct, Generateseries, Generate, Crossjoin
https://youtu.be/cN8AO3_vmlY?t=22350
