Forum Discussion
markefrody
4 years agoPost Patron
Product Count Based on Shift
Hi, I'm trying to count the number of products finished on each manager's time shift. Problem is each manager's shift changes every day. I have two tables containing the following: Table ...
- 4 years ago
My bad, I misunderstood.
I kept the same changes mentioned above and added a new measure and created new visual. Please see if this helpsa) Created a measure part of manager schedule
Prod Count = var _d1 = Minx('Manager Schedule', 'Manager Schedule'[Start Time]) var _d2 = Minx('Manager Schedule', 'Manager Schedule'[Clock Out]) var _Prod_count = CALCULATE( COUNTROWS('Production Schedule'), FILTER('Production Schedule', 'Production Schedule'[Date Finished] >= _d1 && 'Production Schedule'[Date Finished] <= _d2)) return _Prod_count
markefrody
4 years agoPost Patron
sevenhills
Sorry about that. Thank you for letting me know that there are empty fields on the data.
Thank you for helping me. It's working perfectly.
Best regards,
Mark V.
sevenhills
4 years agoSuper User