Forum Discussion
PowerBI Employee Time Tracking Data
Hello, I have been working on a PowerBI report that is intended to tack our student employees time versus their schedules. I have run into several issues, and could use some help. Here is the backgro...
Here is examples of the tables. The first one is actual scans. and the second one is scheduled shifts. I am not sure how to share the PBIX file. The desired output would be a table that lists each shift, and whether that shift was worked, missed, or abscent. The biggest problem is that the students can have multiple shifts with multiple breaks per day. How can i write a formula that checks all of the scans against the each schedule, and will it work ok or be to slow?