Forum Discussion

setis's avatar
setis
Post Partisan
6 years ago
Solved

Calculating sick days

Dear experts,    I am trying to calculate the number of sick days per month.    The challenge is that there are instances where an employee has 2 lines per day (due to the shift distribution) lik...
Need Help
  • az38's avatar
    az38
    6 years ago

    hi setis 

    try a calculated table

    Table = summarize(FILTER('Table';'Table'[Timesheet]="illness");'Table'[Salary ID];"illnessdays";distinctcount('Table'[WorkDay]))

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

     

az38's avatar
az38
Community Champion
6 years ago

hi setis 

try a calculated table

Table = summarize(FILTER('Table';'Table'[Timesheet]="illness");'Table'[Salary ID];"illnessdays";distinctcount('Table'[WorkDay]))

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

 

setis's avatar
setis
Post Partisan
6 years ago

az38 This works, thanks, Would it be possible to obtain the same result with a measure instead?