Forum Discussion
Distributing values periodically between start and finish date
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
2 Replies
- amitchandak
Super User
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
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
