Forum Discussion

efstel's avatar
efstel
Icon for Helper I rankHelper I
2 years ago
Solved

Determining missing row information for current time period compared to last time period

We are having a problem with occasionally missing a person’s pay period due to a location switch. For example, Jane Doe works on one project the previous week and switches to another this week. The n...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi efstel ,

     

    I recommend that you calculate the total number of days of attendance and then subtract the number of days each person was in regular attendance to get the number of days each person was absent.

     

    Suppose you want to check the number of days of absence for everyone from 9/6 to 9/1, you can refer to this.

    All attendance records from 9/6 to 9/1.

    All employees.

    Calculate the number of days each employee is absent.

    Absence = DATEDIFF(DATE(2024,9,1),DATE(2024,9,6),DAY)-CALCULATE(COUNTROWS(Arrived),Arrived[Name]=MAX(Staff[Name]))

     

    Best regards,

    Mengmeng Li

     

Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper User
2 years ago

Create a dummy table of all the employees considering present all the weeks. Now with this table compare your actual one

efstel's avatar
efstel
Icon for Helper I rankHelper I
2 years ago

Okay I have a table that shows all active employees. I want to list the dates where they aren't showing up at all. Since there is no record on that date, that employee doesn't show up in the system that day at all. I'd also like to graphically show a count of missing time entrys on each date as well.