cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jciromil
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
Highlighted
Super User IV
Super User IV

Re: Need to split value between dates

See page 13

 

 


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
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


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

jciromil
Frequent Visitor

Re: Need to split value between dates

Question Modified!

Highlighted
Super User IV
Super User IV

Re: Need to split value between dates

See page 13

 

 


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors