Forum Discussion
Average from measure with Datediff
Hi All,
I have a measure which I am using to calculate the hours an employee is on site by using the first and last times they are utilising the access control system.
Hours Present = DATEDIFF(MIN('Access Report'[Date/time]),MAX('Access Report'[Date/time]),MINUTE)/60
However we now need to calculate the average hours present on any given day of the week based on the employees selected / and / or month / date etc. (using slicers as filters).
A sample of my table is attached.
Thanks
hi Gazsim44
It's pleasant that your problem has been solved, 😁
For measure totals problem. it is a common problem, there is another blog for you refer to:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376please accept my reply as answer, that way, other community members would easily find the solution when they get same issues.
Regards,
Lin
4 Replies
Gazsim44 , refer to my blog on this. You need to give correct row context using summarize or values
hi Gazsim44
here is a similar post for you refer to:
https://community.powerbi.com/t5/Desktop/convert-measures-to-column-for-correct-average/m-p/1145598
If you still have the problem, please share your sample pbix file and your expected output.
Regards,
Lin
Hi, I've found that this solution from Greg_Deckler has successfully managed what I needed.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
The issue was initially in the totals not calculating correctly so once resolved obtaining the average was relatively easy!
Thanks,
hi Gazsim44
It's pleasant that your problem has been solved, 😁
For measure totals problem. it is a common problem, there is another blog for you refer to:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376please accept my reply as answer, that way, other community members would easily find the solution when they get same issues.
Regards,
Lin
