Dynamic Function To Count Values in a Date Range

Hi  mmcquil2 ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Date = CALENDAR(MIN('Table'[start date]),MAX('Table'[end date]))

2. Create measure.

Count_open =
var _select=SELECTEDVALUE('Date'[Date])
var _maxdate=EOMONTH(_select,0)
var _mindate=DATE(YEAR(_select),MONTH(_select),1)
return
COUNTX(FILTER(ALL('Table'),'Table'[end date]>=_mindate&& 'Table'[end date]<=_maxdate&&'Table'[end date]<>BLANK()),[Orders])

Flag =
var _select=SELECTEDVALUE('Date'[Date])
var _maxdate=EOMONTH(_select,0)
var _mindate=DATE(YEAR(_select),MONTH(_select),1)
return
IF(
    MAX('Table'[end date])>=_mindate&& MAX('Table'[end date])<=_maxdate&&MAX('Table'[end date])<>BLANK(),1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

When selecting 2022.3.20 in the calendar table, the count of [End date] in this March 2022.3.1 and 2022.3.31 time interval will be displayed in Viusal. If it is empty, it will not be counted.

Please click here for the pbix file.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly