PowerBI Attrition Dashboard for Monthly and yearly

[Chandra_maha]

Hi All,

I am trying to create monthly/Yearly PowerBI attrition. Following is data. 

Attrition = Total No of employee left for month/No of average employee for month*100

Number of average employee = no of employee at the start of the month + no of employee at the end of the month/2

The desire output is 

Thank you!

[Ashish_Mathur]

Use the DATESBETWEEN() function.

[Chandra_maha]

Thank you for that. Actually I am trying to create graph. As shown below

Blue one - Regular month on month Attrition graph. Which we have created already
Red one (Need to create) - Attrition graph for 6 month.
Example - Suppose I am click June then it will give me the attrition percentage of last 06(Jan to June) month and it will be go on.
Suppose I click on Aug then it be from march to Aug. I am trying to get that. Can you help me on this.
You can consider the same data set. 

[Ashish_Mathur]

I may not be able to devote so much time to solving this one.  May be someone will help you.

[Chandra_maha]

Thank, you have helped me a lot 🙂

[Dhacd]

@Chandra_maha , can you give clarity on number of average employees?

[Chandra_maha]

Ex -

As you can in above January table -  at the start of month No. of employee is 1. This is "no of employee at the start of the month"
And if you add all the employee joined in that month then its 32. This is "No of employee at the end of the month".

[TeeJay80]

Hi, could you please upload the attrition file, so I could use it for my data? Thanks in advance!

[Dhacd]

Should we add all the employees who joined in January and subtract those who left the company to find the no of employees at the end of the month?

and what if December had about 15 employees joined, Should we consider them for the no of employees at start of the month for Jan? 

[Chandra_maha]

Hello,
Yes, we need to conside as you mention. I have created table for explanation 

Month	Hired Employee	Left Employee	Start of the Month	End of the Month
Dec'14	2	0	0	2
Jan'15	1	0	2	3
Feb'15	2	0	3	5
March'15	1	2	5	3
April'15	4	1	3	6

We get "End of Month Employee" count by adding "Hired Employee" and subtracting "Left employee". 
Also, last month "End of month Employee" (Dec'14 = 2) would be "Start of the month employee" count (Jan'15) = 2