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.

2 Replies

  • 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.
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Share some data to work (in a format that can be pasted in an MS Excel file.) with and show the expected result.