One Example, which is subject to delegation warnings (so only use it if your sharepoint source is under the 500/2000 (depending on your settings) row threshold.)
On the start dates date picker, place in onchange
Set(startdateVar,
DateTimeValue(
Concatenate(
"11:59 PM ",
Date(Year(DatePicker2.SelectedDate),Month(DatePicker2.SelectedDate),Day (DatePicker2.SelectedDate))
)))
In the end dates,
Set(enddateVar,
DateTimeValue(
Concatenate(
"12:00 AM ",
Date(Year(DatePicker3.SelectedDate),Month(DatePicker3.SelectedDate),Day (DatePicker3.SelectedDate))
)))
We do this because by default datepicker is setting them both to 12am which will technically return wrong in between dates as it will include dates ON the start date.
Now if you have a smaller datasource under the threshold a simple label with the following will count the rows where DATE falls between selected dates
CountRows(
Filter(
SalesEvalCurrent,
DATE>startdateVar &&
DATE<enddateVar))
)
If you are over threshold you will need to first collect the ones that match, because countrows is not delegable.
You can do that by placing the following on a button, or in both onchanges of datepickers, etc wherever you want really.
ClearCollect(MyDateRange,
Filter(
SalesEvalCurrent,
DATE>startdateVar &&
DATE<enddateVar)))
after which you simply have the label count that new local collection
