Forum Discussion
Solved
Average process time issues
Hi there! I would like to create a visual of the average process time of multiple issues of an organisation. In the screenshot you can see the fields were available. So, when the Status colum...
Ok. I guess I need to see the file to help you better.
Nonetheless, the custom column that you created earlier, you can still use it and display the Average using a QnA visual or by right clicking on your column name under the Values section of your visual and selecting "Average" from there.Thanks,
Dheeraj
Allright dkaushik, my TableName = 'Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)'. So i used:
Average Process Time = Calculate(sum('Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)'[LastModified]) - sum('Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)'[Created]))
PowerBI says 'A circular dependency has been detected: Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)[Column], 4a291644-1c12-4a82-bda5-e18c995cabd1, Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)[Column].
Ok. I guess I need to see the file to help you better.
Nonetheless, the custom column that you created earlier, you can still use it and display the Average using a QnA visual or by right clicking on your column name under the Values section of your visual and selecting "Average" from there.
Thanks,
Dheeraj