Forum Discussion
How to sum overlapping values in a time range?
In the example below, Projects A, B, C and D overlap, having a total of 37 points and 3 Project Managers (PM), and later projects A, D and E overlap for a short while, having a total of 34 points for a few days. I need now to find a way to sum the Points that overlap in time, and somehow plot it in a chart, divided by PMs. The goal is to be able to see the total amount of Points at any given time by PM for project planning. How could I go about it using DAX? I am thinking in the direction of the EARLIER function, but being a Power BI relative newbie, I am not sure how to set it up. Does anyone have an input?
| Project Title | Start date | End date | Points | PM |
| Project A | 12/04/2019 | 16/07/2023 | 15 | Michaela |
| Project B | 18/06/2020 | 15/05/2022 | 7 | Wes |
| Project C | 01/12/2021 | 19/04/2023 | 3 | Michaela |
| Project D | 20/04/2019 | 14/07/2023 | 12 | Asher |
| Project E | 09/07/2023 | 17/08/2024 | 7 | Laurel |
Hi Anonymous ,
Based on your description, I created a sample pbix for your reference.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , Check one of these two blogs or the attached file on a similar topic should help
V-lianl-msftCommunity Support
Hi Anonymous ,
Based on your description, I created a sample pbix for your reference.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
