Forum Discussion
College Class Schedule Analysis
Yeah, I was considering that approach as well but by the quarter or half hour. How did you manage creating the timeblocks? Did you create a column for each minute or use something like R to automate this?
kw127533,
I created a lookup table with 1,440 rows for the minutes througout the day and then used DAX to evaluate if the minute of time fell between class start/stop time. This gave me bands of rows that could be used for density plots. Don't recall all the details as I've been busy with other projects but hope to get back to it again soon.
I am absolutely sure there is a much more elegant way to do this that uses pure DAX without a lookup table but this is the approach I used to quickly solve the problem. The calendar feature of Power BI may also facilitate this kind of analysis but I"ve not had time to explore. I'm also sure others in this forum has solved similar problems but during my search, I wasn't able to find the solution I was after.
Good luck!
Well that's definitely a better solution than what I had in mind and anything I found in the forums. Thanks for the information! I'll keep you posted as to how my analysis goes.