Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need to split value between dates

Power BI Expected output

 

Data present in database

 

Guys,

 

Need help in splitting the Employee Count based on joining date between several months of the year. I have employee database that contains records of employee and say I have 400 employees that have joined in past year. Now I need to show a report that will list down Employees count whose value will split across months from previous year. Here, say my year range is Oct 2017 to Sep 2018.

 

Example: Below is what my report should look like. 

 

Employee Type       TOTAL COUNT     Oct 2017     Nov 2017   Dec 2017... . .. . .....  . . Aug 2018  Sept 2018

Part -Time                 100                          10                25              40               .. . .. . . ..   45              65

Full-Time                   300                          40                45              75   .  ... . . . . . ...... .....   25             40

 

How do I split the employee data across one year span. I need to take joining dates as a reference and from there count on months but I'm not sure about splitting the data

 

 

 

Regards

3 Replies