setisPost Partisan6 years agoSolvedCalculating 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...Show Moreaz386 years agohi setis try a calculated tableTable = 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 solutionLinkedIn
az386 years agohi setis try a calculated tableTable = 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 solutionLinkedIn
az386 years agohi setis try a calculated tableTable = 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 solutionLinkedIn
az38Community Champion6 years agohi setis try a calculated tableTable = 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 solutionLinkedIn
setisPost Partisan to az386 years agoaz38 This works, thanks, Would it be possible to obtain the same result with a measure instead?
setisPost Partisan to az386 years agoaz38 This works, thanks, Would it be possible to obtain the same result with a measure instead?
Related contentCalculate Rolling Sickness Rate From Cumulative DataSetCases per Day CalculationCalculated daysCalculate Rolling 12 Month Sickness RatioWith a list of sick days how to calculate occurrences for each employee
