Forum Discussion
Want to display monthly average time
Hi,
I am creating a dashboard for our call centre section and I want to display the average call and wait times which I have listed in my data as times, example below. The list is by day, so the second row down is 02/01/2025 the average call time that day was 1 minute 36 seconds.
However, when I try and display this it only gives me the option of earliest/latest time and sometimes doesn't pick that up correctly either. I have tried inputting a DAX code to create a 'month' column and then pulling through the averages, and then I have tried the DAX to turn the column into minutes but nothing seems to be working. Any help or tips appreciated please!!
hi WildIOM123,
Thank you for reaching out to Microsoft Fabric Community Forum.
bhanu_gautam Thank you for you prompt response.
I have created and attached a sample Power BI file and included the DAX for Average of minutes based on the sample data. Please review the file and confirm if it meets your expectations. If not, kindly share your sample data along with the desired output, so I can make the necessary adjustments accordingly.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,B Manikanteswara Reddy
2 Replies
- bhanu_gautam
Super User
WildIOM123 Open Power Query Editor.
Select your time column (e.g., Average Talk Time).
Split the column into hours, minutes, and seconds if necessary.
Create a custom column to convert these into a duration.m
= #duration(0, [Hours], [Minutes], [Seconds])After converting the time columns to duration, close and apply the changes.
Create a new measure to calculate the average duration.AverageTalkTime = AVERAGE('TableName'[Average Talk Time])
AverageWaitTime = AVERAGE('TableName'[Average Wait Time])
hi WildIOM123,
Thank you for reaching out to Microsoft Fabric Community Forum.
bhanu_gautam Thank you for you prompt response.
I have created and attached a sample Power BI file and included the DAX for Average of minutes based on the sample data. Please review the file and confirm if it meets your expectations. If not, kindly share your sample data along with the desired output, so I can make the necessary adjustments accordingly.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,B Manikanteswara Reddy
