Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am reporting on call queue data pulled out of Zoom.
What I have in my table is:
Time Call Started (the first moment it came into the queue) Ex: 02/23/2024 2:49:00am
Total duration they were in the queue and handled. Ex: (minutes) 4.7333
I am asked to report on how many calls were in the queue at any given time. How many were waiting in the queue. I assume there is some way to do this because I know when the call started and how long it lasted. So I should be able to see how it stacks up and then report on it.
I have no idea how to create a measure or even just a report on something like this.
Solved! Go to Solution.
Hi @Thomas_MedOne ,
I would create a seperate date/time table and do not relate it to the zoom data table.
Create a slicer on that table.
Then create a measure like this
CallsInQueue=
var SelectedDateTime= Selectedvalue(DateTimeTable[DateTime])
return
Calculate(Countrows([ZoomDataTableName]), FILTER(ZoomDataTableName, ZoomDataTableName[DateTime]= SelectedDateTime))
@djurecicK2 Thank you very much for your prompt reply and here allow me to share some of it.
To create an hourly or half-hourly date/schedule in Power BI, you can try the following:
Create a table.
For hourly intervals, the incremental value 1/24 can be used.
Table = GENERATESERIES(DATE(2021,1,1), NOW(), 1/24)
For half-hour intervals, you can use the 1/48.
Table = GENERATESERIES(DATE(2021,1,1), NOW(), 1/48)
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am not sure why a solution was accept on my post. I haven't tried this yet because I have payroll this week and do not have the time to try this out yet.
@djurecicK2 Thank you very much for your prompt reply and here allow me to share some of it.
To create an hourly or half-hourly date/schedule in Power BI, you can try the following:
Create a table.
For hourly intervals, the incremental value 1/24 can be used.
Table = GENERATESERIES(DATE(2021,1,1), NOW(), 1/24)
For half-hour intervals, you can use the 1/48.
Table = GENERATESERIES(DATE(2021,1,1), NOW(), 1/48)
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Thomas_MedOne ,
I would create a seperate date/time table and do not relate it to the zoom data table.
Create a slicer on that table.
Then create a measure like this
CallsInQueue=
var SelectedDateTime= Selectedvalue(DateTimeTable[DateTime])
return
Calculate(Countrows([ZoomDataTableName]), FILTER(ZoomDataTableName, ZoomDataTableName[DateTime]= SelectedDateTime))
I tried creating a Date/Time table with this below. It's all midnight. How do I create one with each hour of the day? Perhaps every half hour?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |