topic Re: Distributing values periodically between start and finish date in DAX Commands and Tips

Distributing values periodically between start and finish date

muralikrishnan — Fri, 18 Dec 2020 08:35:28 GMT

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

Re: Distributing values periodically between start and finish date

amitchandak — Fri, 18 Dec 2020 09:33:42 GMT

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-or-end-date/ba-p/1503785

Re: Distributing values periodically between start and finish date

muralikrishnan — Sat, 19 Dec 2020 13:24:12 GMT

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