Forum Discussion
NaveenMD
Helper I
Helper Ihow to count values between 2 date/time variable where date time variable can be duplicate
How can I can I calculate values between 2 date/time ranges where Date values can be duplicate. Book1 1.xlsx amitchandak
amitchandak
Super User
Super UserNaveenMD , Try if this can help
Count =
VAR _min = [start time adjusted]
VAR _Max = [finish time adjusted]
RETURN
CALCULATE(
COUNTROWS(Table),
FILTER(
Table,
[start time adjusted] >= _min &&
[finish time adjusted] <= _Max
)
)