How to get month over month Running Count

BMT

New Member
Joined
Jun 23, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top