Apportion values based on date field

[Ry_009]

Hello all

Please bear with me, as my programming and Power BI skills are still relatively basic. Have done a search and couldn't find anything related to my query.

I was wondering if it was possible to equally apportion values over time based on a date field?

Data is based on enrolment units, with a number value for hours and start and end date values.

Eg Row level Data:

Unit Name              Department                   Hours                 Start Date            End Date
ABC                         Electrical                        30                      1/01/2021            31/03/2021
DEF                         Hospitality                     50                      1/03/2021             31/04/2021

Based on the data above, would equally distibute the hours value over time based on the start and end dates, so it would look something like this, is this even possible?

Total Hours by Department

Department                 Jan 21           Feb 21          Mar 21            Apr 21
Electrical                      10                  10                10
Hospitality                                                             25                   25

Total                            10                  10                35                   25

Again my skills are still basic and this may be a very stupid question. Apologies in advance. Apologies for the formatting also.

[Ry_009]

Amit, wow, thank you so much for your assitance, after a bit of trial and error, it worked great!

Is there a way though to distribute evenly by months? 

I would love to learn more from you via your videos, do you have particular one where I could learn this functionality in more detail? Or start with your beginner videos?

Thanks again, have really made a difference to my learning 🙂

[amitchandak · Accepted solution]

@Ry_009 ,

I have a blog for day level, you can do it at month level

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Or consider file for new table