Forum Discussion

markefrody's avatar
markefrody
Post Patron
4 years ago
Solved

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 ...
Need Help
  • sevenhills's avatar
    sevenhills
    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 helps

     

    a) 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

     

     

     

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Since you want the output to be date wise, I am assuming that the time stamp appearing in each of the 2 tables is not required.

markefrody's avatar
markefrody
Post Patron
4 years ago

Ashish_Mathur 

Hi Ashish,

Thank you for your reply.

For the output, time stamp is not required.

Best regards,
Mark V. 


  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    There should be another table which maps the products to managers.

      • sevenhills's avatar
        sevenhills
        Super User
        4 years ago

        1. Create column as Date part only

         

        Date Finished DT = DATEVALUE('Production Schedule'[Date Finished])

         

         

        mark the format as "mm/dd/yyyy" to the new column

        similar format to Manager schedule - start date column.

         

        2. Adjust the model    and see if it works for your needs

         

         

        See if this helps