Forum Discussion
Bad calculate result
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 Select your measure and go to the Modeling tab. The options for data type and formatting are there.
There is no option to chage the data type at all, and as u see no option to define the format to 'date time'.
Thank a lot!
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?
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!