Forum Discussion
Count of Active Projects between two dates
My apologies if this exists already, i have been searching and found similar, but nothing that has worked when tested out, nor seems to fit this need. I have a table with a Project ID, Start Date...
Hi,
My method creates one row for each month between the beginning and ending date. You will see all steps in the Query Editor.
helo,
i have a simple table with project id, yard, start and end date of multiple projects. i want to create a histogram that shows the no of active projects by week. eg:
Project Yard Type start end
| msc | china | NB | 16/06/2023 | 20/03/2023 |
| carnival | china | RF | 17/06/2023 | 24/03/2023 |
| maersk | korea | RF | 20/06/2023 | 21/03/2023 |
eg: in this case, the histogram should have the value as 2 for the date17/6/23 as 2 projects are in progress and when i click on this, it should show me the project ID, yard of the 2 projects that are in progress. how can i achieve this best
Hi,
You may download my PBI file.
Hope this helps.