Forum Discussion

ringovski1's avatar
ringovski1
Regular Visitor
5 years ago

Total & Average Hours

Hi All,   I am trying work out the total average hours per request, a request can have 1 to x phases(rows). I have correctly calcucated the duration Hours & Weeks though the AVG & SUM hours are inc...
Help appreciated
Help with DAX
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ringovski1 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Try like

AVG Duration HRS =calculate(DIVIDE([Duration HR], count(boardingdata[PhaseTxt])), values(boardingdata[PhaseTxt]))