Forum Discussion
All Quarters between a project start date and a project end date; then calc how many days in e quart
Working on a project tool. Each project has a start date, duration, with calculated end date. My customers need to see a visual that lists the number of days in each quarter that the project will be worked on.
Example:
Start date: 2/1/2020
Duration (days): 175
End date: 7/24/2020
3 Quarters are impacted by this project. 2020-Q1, 2020-Q2, and 2020-Q3. I need a calculation that will return all of those quarters AND how many of the project days are in each of those quarters.
End result:
Quarters Days
2020-Q1 60
2020-Q2 90
2020-Q3 25
Thank you for your help!
2 Replies
- amitchandak
Super User
Make sure you have a calendar table.
Try this
calculate(count(date[date]),all(date[date]),filter(table,table[start_date]<=max(date[date]) && table[end_date] >=min(date[date])))
