cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jciromil Frequent Visitor
Frequent Visitor

Need to split value between dates

Output File.PNGPower BI Expected output

 

Input File.PNGData 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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Need to split value between dates

See page 13

 

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Need to split value between dates

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


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

jciromil Frequent Visitor
Frequent Visitor

Re: Need to split value between dates

Question Modified!

Super User IV
Super User IV

Re: Need to split value between dates

See page 13

 

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors