Forum Discussion

Nazish's avatar
Nazish
Icon for Helper I rankHelper I
4 years ago
Solved

How to calculate Average per type/category?

Hi PowerBi Community,   I want to calculate Average of RespTimeMins by Issue Type (monthly and yearly) and I have below data columns (Issue Type, RespTimeMins, month and year) in my table.  please...
Need Help
  • Syk's avatar
    Syk
    4 years ago

    Remove the measure and just put the response time field in the table then select average. (No measure needed for this)

Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
4 years ago

Set your data type to duration and then you can select which type of duration you want to convert it to.

 

Nazish's avatar
Nazish
Icon for Helper I rankHelper I
4 years ago

Thankyou so much, I have been looking for this solution from so many days but wasnt getting it. You have helped me alot.

Thankyou so much again. much apperciated.