All Quarters between a project start date and a project end date; then calc how many days in e quart

[Anonymous]

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!

[amitchandak]

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])))

[Anonymous]

There is a calendar table. I do not understand how your solution will calculate the number of project days in each quarter. Please look at the original post under "End Result".