i have 2 sheets. on 1st sheet there are active employee list (Emp id, Emp Name, Country, City, Gender, Project Name, DOJ, Reporting Manager Name, Financial Year as FY22, FY23, FY24) and 2nd sheet has inactive employee list (Emp id, Emp Name, Country, City, Gender, Project Name, DOJ, Reporting Manager Name, Financial Year as FY22, FY23, FY24, Attrition type, Attrition Reason, Attrition Exclusion (if we don't count as attrition we use to update Yes there. suppose if any employee get retire then we dont count as attritoin so we updated exclusion as yes.)
My need is to get Month on month Headcount, Attrition Count, and attrition%
Formula to calculate Attrition% is (Running Attrition Count/Running Headcount)*12. We use this formula to annualize the attrition%
i want to create a DAX in PowerBI that can calculate Month on month running count, Month on month running attrition so that i can calculate the Running Attrition% For a year (Suppose if i am filtering FY22 then i need From April'21 to March'22 month on month Running attrition% ) and that DAX should work with filter context as well suppose if i am selecting any particular project then DAX should also get updated.
Thanks in advance. I tried it many times but not able to get the result.
My need is to get Month on month Headcount, Attrition Count, and attrition%
Formula to calculate Attrition% is (Running Attrition Count/Running Headcount)*12. We use this formula to annualize the attrition%
i want to create a DAX in PowerBI that can calculate Month on month running count, Month on month running attrition so that i can calculate the Running Attrition% For a year (Suppose if i am filtering FY22 then i need From April'21 to March'22 month on month Running attrition% ) and that DAX should work with filter context as well suppose if i am selecting any particular project then DAX should also get updated.
Thanks in advance. I tried it many times but not able to get the result.