Forum Discussion

bigrods's avatar
bigrods
Helper III
1 year ago
Solved

Sickness data - duplicate rows generated with same Absence Start Date

Hi,   I wasn't really able to describe my issue in the Title bar, hope I can here! I have some Employee Sickness data that I need to identify the Sickness Ratio per month from, but the data is disp...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi bigrods ,

    You can use this DAX to create a calculated table:

    SummarizedAbsences = 
SUMMARIZE(
    EmployeeAbsences,
    EmployeeAbsences[Assignment No],
    EmployeeAbsences[First Name],
    EmployeeAbsences[Last Name],
    EmployeeAbsences[Absence Start Date],
    EmployeeAbsences[Absence End Date],
    "Total Days Lost", SUM(EmployeeAbsences[Days Lost])
)

    And the final output is as below:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi bigrods ,

You can use this DAX to create a calculated table:

SummarizedAbsences = 
SUMMARIZE(
    EmployeeAbsences,
    EmployeeAbsences[Assignment No],
    EmployeeAbsences[First Name],
    EmployeeAbsences[Last Name],
    EmployeeAbsences[Absence Start Date],
    EmployeeAbsences[Absence End Date],
    "Total Days Lost", SUM(EmployeeAbsences[Days Lost])
)

And the final output is as below:


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • bigrods's avatar
    bigrods
    Helper III
    1 year ago

    Great, thanks a lot, this has worked!