Forum Discussion
Helper Iproject value distributed over upcoming months
Tables:
Duration (duration refers to months here)
| Department | Duration |
| Dep1 | 1,5 |
| Dep2 | 2 |
Project
| ID | Name | Department | StartDate | Value |
| 1 | Project1 | Dep1 | 04-10-2021 | 50.000 |
| 2 | Project2 | Dep2 | 04-10-2021 | 40.000 |
My goal is to visualize the project values for the upcoming months. There are two solutions, both would be of interest:
- For example, disregarding that StartDate is a date and threating it only on monthly level. So that Project ID 1's value would be split between October (33.333) and November (16.667).
- Treat StartDate as a Date, and factor in the remaining days or workdays of the month.
akos_skutovics , refer if the attached file or two blogs can help
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
1 Reply
- amitchandak
Super User
akos_skutovics , refer if the attached file or two blogs can help
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