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

     

Anonymous's avatar
Anonymous
Not applicable
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

 

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

That's not quite what I am looking for. I need to pull the names of the actual persons not in attendance. I don't need a count.

 

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

    Hi,

    As you havenot shared any sample data, I assumed the dataset as below

    Based on this employee C and D missing this week.

    here how I flaghged it using measure

    Is this whate you are asking?