Forum Discussion
Count of Active Projects between two dates
Hi,
Share some data that i can work with. I should be able to paste that data in an Excel file. If possible, please also show the expected result.
Its a simple table, Project list with Start and finish dates. Two Finish dates remain open because those projects are still active.
| Project | Start Date | Finish Date |
| Project 1 | 1/1/2018 | 5/7/2018 |
| Project 2 | 2/8/2018 | |
| Project 3 | 5/5/2018 | 8/20/2018 |
| Project 4 | 8/23/2018 | 8/24/2018 |
| Project 5 | 6/5/2018 | |
| Project 6 | 7/2/2018 | 8/10/2018 |
| Project 7 | 7/4/2018 | 8/9/2018 |
As i'm new to this, Its hard for me to show what the intended result should be visually... using a date slicer (slider) i would like to be able to change the dates, and have a card visual show the count of projects that were Active between the dates of the Slider. So if the dates of the Slicer are 8/20/18 and 8/23/18, it should show a count of "4".
Hope this helps illustrate better
This is great, thank you both for the help. however, the real data table I am using is Thousands of lines long. A crossjoin table to have each possible date the project is open is not feasible due to size and performance concerns.