Forum Discussion
Combining multiple rows in data table with calculation
Hi Everyone, I'm building a report using Power BI and am stuck on a calculation i'm trying to achieve. I have an excel file; with a couple of columns. For the sake of this example, let's refer to...
Anonymous , You have to create time in second and then take avg
New colum= hour([AHT])*3600 + minute([AHT])*60 + second([AHT])
Not you can create a meausre
Avg AHT = average([New column])
You can use new dynamic formatting
use a format like
"""" & QUOTIENT([net time],3600) & ":" & QUOTIENT(mod([net time],3600),60) & ":" & round(mod(mod([net time],3600),60),0) & """"
Anonymous , You have to create time in second and then take avg
New colum= hour([AHT])*3600 + minute([AHT])*60 + second([AHT])
Not you can create a meausre
Avg AHT = average([New column])
You can use new dynamic formatting
use a format like
"""" & QUOTIENT([net time],3600) & ":" & QUOTIENT(mod([net time],3600),60) & ":" & round(mod(mod([net time],3600),60),0) & """"