Forum Discussion

WildIOM123's avatar
WildIOM123
Regular Visitor
1 year ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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