Forum Discussion
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...
I just meant the difference between mine without divide:
WaitingTimeAvgSec = SUMX(WaitingTable,WaitingTable[NumCalls] * WaitingTable[WaitingTimeAvg] * 86400) / SUM(WaitingTable[NumCalls]
and yours with divide:
MEASURE = divide(SUMX(Table[NumCalls] *Table[WaitingTimeAvg]*86400),SUM(Table[NumCalls]))
ryan_mayu
Super User
Super UserDivide Performs division and returns alternate result or BLANK() on division by 0.
https://docs.microsoft.com/EN-US/dax/divide-function-dax