Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
See page 13
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
Question Modified!
See page 13
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |