Forum Discussion
String Days and Hours, monthly
Hi, I have a column which reports time worked in hours (per id/row). This I can report on monthly and I can calculate monthly average. However I am converting the hours using DAX to display Day...
create an hourly measure. Create an avg of the sum.
Refer - this is the sum of Avg
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
Then format this column to show final result in day format
Thank you for the steer, I am getting a circular reference error, I must be going wrong somewhere
