Forum Discussion
Average calculation issue with Direct Query mode
Hello, I'm currently working on Sprinklr data exploitation in PowerBI by using the dedicated Spark connector (DirectQuery mode). All is going fine except for duration average calculation. I'm...
Anonymous , If you duration is minute or second
Meausre =
var _avg = average(Table[Duration])
return
Quotient([_avg ],86400) & " Day :" Quotient(mod([_avg],86400),3600) &" Hours :" & Quotient(mod(mod([_avg ],86400),3600),60) &" Minute :" & mod(mod(mod([_avg ],86400),3600),60)