Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX formula for Attrition Rate

Hi experts, Need to create Attrition Rate formula for HR dashboard Please help  
Need Help
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    Hi Anonymous ,
    create a measure :

    Attrition Rate % =
    VAR __BASELINE_VALUE = SUM('Table'[No. of Emp That Left During Period])
    VAR __VALUE_TO_COMPARE = AVG('Table'[No. of Emp for Period])
    RETURN
        IF(
            NOT ISBLANK(__VALUE_TO_COMPARE),
            DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE) *100
        )
    Thanks,
    Please mark this as the column if you found it helpful.
pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Anonymous ,
create a measure :

Attrition Rate % =
VAR __BASELINE_VALUE = SUM('Table'[No. of Emp That Left During Period])
VAR __VALUE_TO_COMPARE = AVG('Table'[No. of Emp for Period])
RETURN
    IF(
        NOT ISBLANK(__VALUE_TO_COMPARE),
        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE) *100
    )
Thanks,
Please mark this as the column if you found it helpful.