Forum Discussion
Counting Events in Times Slots
I am looking for a way (correct measure formular) to count events in times slots, which include events when spans over a single 1 hour period.. Also should there be a time dimention table which i...
MKeppel , Create table using generateseries
Time = generateseries (1,24,1)
then join it with start
Create measure like
count(Table[Day])+0
That will not achieve what I am after.
If a booking goes over two houes, I want it to count +1 for each hour it is in.
So I will need it to filter the counting row if the Time >= starttime & < endtime.
