Need to split value between dates

[Anonymous]

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

[Greg_Deckler]

Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[Anonymous]

Question Modified!

[Greg_Deckler · Accepted solution]

See page 13