Forum Discussion

SnirSh's avatar
SnirSh
Regular Visitor
10 years ago
Solved

Bad calculate result

hey, im trying to calculate avg of a time colum (hh:mm:ss) but its not going well, anyone have an idea?    
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    SnirSh oh yeah, I forgot that DAX doesn't really support duration data. Are the results of this average always going to be less than 24 hours? The few I can see look pretty short. If so you can change your measure to

     

    AVG TIME IN QUEUE = FORMAT( AVERAGE(CTI[AVG wait time]), "HH:mm:ss")

     

    If it can be more than 24 hours, this will be more complicated. What is the data type of your wait time column?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

SnirSh oh yeah, I forgot that DAX doesn't really support duration data. Are the results of this average always going to be less than 24 hours? The few I can see look pretty short. If so you can change your measure to

 

AVG TIME IN QUEUE = FORMAT( AVERAGE(CTI[AVG wait time]), "HH:mm:ss")

 

If it can be more than 24 hours, this will be more complicated. What is the data type of your wait time column?

SnirSh's avatar
SnirSh
Regular Visitor
10 years ago

Yes, the AVG result alway will be around a few minutes.

I changed the formula like you said and its looking good now!

u r the best!