Total for period within a date range

[Anonymous]

Hi,

I have a table with a number of rows that display start date, end date and the total number of days in between the two. I would like to be able to dynamically filter the table so that it would just give me the number of days in, for example, the quarter from 1st July 2018 to 30th September 2018. The result for this quarter using the following table ought to be 40. I thought this would be straightforward, but I'm struggling to make it work.

Date From	Date To	Number of days
12/01/2001	19/03/2001	66
14/01/2002	11/03/2002	56
13/04/2010	26/04/2010	13
15/10/2012	29/10/2012	14
19/11/2013	22/11/2013	3
22/11/2013	05/02/2014	75
29/06/2018	09/07/2018	10
09/07/2018	10/08/2018	32
28/03/2019	16/05/2019	49
16/05/2019	03/10/2019	140

[jthomson]

So you're getting 40 on account of 8 from row 7 and 32 from row 8, yes? I would guess there's a way to do it in DAX, but I'd look to a Power Query solution as an alternative, and convert it into a single column with one row for each date between your date from and date to columns, which you can then count the rows of to get your answer. It's a fairly common thing to do, if you search list all dates between two dates you should get your answer