Distributing values periodically between start and finish date

[muralikrishnan]

Hi Experts,

Can you please suggest me DAX measure to distribute the values in "target_qty" column periodically in days between "target_start_date" and "target_finish_date" column as shown in below table for (task_id "121690") with no values on fridays:

taskrsrc_id	task_id	rsrc_id	target_qty	target_start_date	target_end_date	16-09-2020	17-09-2020	18-09-2020	19-09-2020	20-09-2020	21-09-2020	22-09-2020	23-09-2020	24-09-2020	25-09-2020	26-09-2020	27-09-2020	28-09-2020	29-09-2020	30-09-2020	01-10-2020	02-10-2020	03-10-2020
130303	121690	7250	10800	16-09-2020	16-11-2020	207.69	207.69		207.69	207.69	207.69	207.69	207.69	207.69		207.69	207.69	207.69	207.69	207.69	207.69		207.69

Thanks,

Regards,

Murali 

[amitchandak]

@muralikrishnan , With your shared data nor able to make sense.

See if this blog can help

#POWERBI: How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[muralikrishnan]

Hi Amit,

Thanks for your reply. However, I am looking for a measure to distribute the value in [target_qty]column to be distributed in days between target_start_date and target_finish_date leaving all fridays i.e. on 13 Nov 2020, 20 Nov 2020, 27 Nov 2020.....

Thanks,

Regards,

Murali