Forum Discussion
Multiple Counting with a date range criteria
Hello, I'm dealing with a scenario where I have a table named "Table 1" with project ID, start date, and end date columns. What I aim to achieve is to count ongoing projects for each month w...
Hi Dadoge ,
Depending on the requirement you may also have a date sheet, what I have done is to operate on the same date sheet and you can check the result as below:
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your quick answer !
What i meant with the expected results is that with your data set, there should be a spike for each month between 2020-08-20 and 2023-07-04.