How to count the numbers of call occurred in specific interval

[jaypatel]

Hello,
I really need some help with a DAX that gives me a count of call occurrence in a specific time interval.

I have a table of call_logs, there are two columns call_start and call_end that is call started and call ended. I want to show the 15min, 30min, and 1hr count of each interval. It means if I choose 15 min interval then I will show how many calls have occurred in each 15min interval for the whole day.

Any help greatly appreciated.

Thanks,

Jay

[kamaraansumana]

How to calculate the total number of incoming calls and outgoing calls per day uniquely  in a call history and also as per location.

[v-angzheng-msft · Accepted solution]

Hi, @jaypatel 

Maybe this is not the final result you expect, but I am close to the goal. Below is my test file. You can download and view it. Maybe it will give you some clues. You can try to modify it to the result you want.

Result:

Hope this helps

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nvprasad]

Hi You Can try with below

= Var StartTime = CALCULATE(MIN([date_stated])

    Var MaxTime = CALCULATE(MIN([date_ended])

Retrun CALCULATE (COUNTROWS(TABLE]), FILTER(TABLE, date_Stated>= StartTime && date_ended <=Maxtime))

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[jaypatel]

No, It returns 1 next to my columns.
I want to separate the time interval and then add the count row as the expected result.