Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How do I merge course data via MW and TH with time and course number

I was give course data (course number, typical MW, TTH, and time when class is held). I cannot seem to create a table that is Monday, Tuesday, Wednesday, etc. I keep getting a werid heirarchy with odd order. I also have classroom but didn't really mess with that. I want to understand how to merge the split columns of days (I did that as MW and TTH wasn't helpful). Maybe my inital assumption was incorrect. I thought I'd start with looking at time of day, class and day...but I'm getting no where. Any insight would be great.

 

image.pngimage.pngimage.png

 

 
1 REPLY 1
AllisonKennedy
Super User
Super User

@Anonymous I would suggest creating a table of Dates and Times, with no course information in it. Then use this to link to the other tables and see if that helps get you where you need to go. This would be similar to a DimDate table concept if you have read anything on that, but will not be a date table because you also need time element in there, so you will have each date multiple times. You should make sure though that your date time table contains every date and equal time increments (half hourly from looking at your data).

 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.