Forum Discussion

BoPowerBI's avatar
BoPowerBI
Frequent Visitor
6 years ago

Average time calculation, calculated column or measure?

Hi all,   I'm trying to get my head around PowerBI and measures and I couldn't find an answer, please help.   This is an excerpt from my datatable of 18th of June 2020 during different time slots...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

BoPowerBI 

 

I searched some materials online. I didn't find sumproduct function in DAX. That will be better if we only use one measure to get the result.

 

Let's see if anyone else can provide better solution on this.

BoPowerBI's avatar
BoPowerBI
Frequent Visitor
6 years ago

Thanks for pointing me toward sumproduct. I actually found it in this article.

Syntax: = SUMX(<Table>, <expression>)

Solution:

 

 

WaitingTimeAvgSec = SUMX(WaitingTable,WaitingTable[NumCalls] * WaitingTable[WaitingTimeAvg] * 86400) / SUM(WaitingTable[NumCalls]