Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@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
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |