Forum Discussion

Divyanshkapoor's avatar
Divyanshkapoor
New Member
3 years ago

need dax help

Scenario: I have a report that needs me to calculate the frequency of absenteeism impact per employee. The condition is, 1 date will be count as 1, and consecutive date will also be count as 1. If t...
Mehdi_Rizvi's avatar
Mehdi_Rizvi
Icon for Advocate I rankAdvocate I
3 years ago

You can try this DAX :

Absenteeism Frequency = 

VAR PreviousDate = MIN('YourTable'[Date]) - 1

RETURN

SUMX(

    FILTER('YourTable',

        'YourTable'[Employee] = SELECTEDVALUE('YourTable'[Employee]) &&

        ('YourTable'[Date] - PreviousDate > 1 ||

        WEEKNUM('YourTable'[Date]) <> WEEKNUM(PreviousDate))

    ),

 

    1

)