College Class Schedule Analysis

You'll want to leave the time table as is. The additional column will be added to your original data table. For example, my original table (let’s call it MySchedule) had columns for each course, with the day of the week it meets, the start time, end time, etc (see attached sample report). In the MySchedule table you'll add the new column with the formula. You'll go to the Power Query Editor (you can get here by clicking the Transform data button in the ribbon), selecting your table in the left-side pane, going to the Add Column tab of the ribbon and selecting Custom Column. This is where you’ll enter your formula using your start and end time columns, creating a new column called 'Meet Times'.

= {[Start_Time_Column]..[End_Time_Column]}

In the example, this formula will create a list of all numbers between 1000 and 1100 for ABC 101. Once you click the top right of that column to expand it, it creates a new row for each value in the list. Then you'll need to filter that list since you'll get non-time values such as 1099. 

Then, convert the Meet Times column back to a time value, close out of the query editor and create a relationship between your new, Meet Time, column and the Time Table, Time column.

Hopefully the example report I provided helps it make more sense! Let me know if you have any issues- always happy to help!

Power BI Sample Report