Apportion values based on date field

Question

Hello all&nbsp;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.&nbsp;I was wondering if it was possible to equally apportion values over time based on a date field?&nbsp;Data is based on enrolment units, with a number value for hours and start and end date values.&nbsp;Eg Row level Data:&nbsp;Unit Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Department&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hours&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Start Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End DateABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Electrical&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/01/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/03/2021DEF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hospitality&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/03/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31/04/2021&nbsp;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?&nbsp;Total Hours by Department&nbsp;Department&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mar 21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Apr 21Electrical&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10Hospitality&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25&nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 35&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25&nbsp;&nbsp;Again my skills are still basic and this may be a very stupid question. Apologies in advance. Apologies for the formatting also.&nbsp;

amitchandak · Accepted Answer

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-or-end-date/ba-p/1503785
&nbsp;
Or consider file for new table

Forum Discussion

Apportion values based on date field

2 Replies

Related content

Getting value for previous year based on value name and year slicer

Values not averaging correctly based on date

Filter a column with duplicate values based on the highest Index value

Apportioning values on Power BI

Max value based on filter