Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating difference between two time values column and finding its average

    Hi Everyone,   I need your help to solve a problem that I am facing. I have two columns which have time based value as shown in the picture:                             ...
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try a measure

     

    Measure = format(calculate(averagex('Table',TIMEVALUE('Table'[Avg store reach time]))),"HH:MM:SS")

     

    or

     

    Measure = format(averagex('Table',TIMEVALUE('Table'[Avg store reach time])),"HH:MM:SS")

     

    depends on business logic

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

"Avg Store reach time" is of STRING datatype because your calculation as below returns a text type of value:

Duration.ToText([Reached Merchant]-[Assigned At]))

 

Thanks,

Pragati