Forum Discussion
Average Time per Item Code
Hi AaronRogers3,
Based on my test, you could refer to below steps:
1.I have entered some sample data:
2.Create a new measure and a Table visual and now you could get the average times for per Item Code.
A = var t = SUMMARIZE('Sheet3',Sheet3[ID],"avgtime",FORMAT(AVERAGE(Sheet3[Cleaningtime]),"HH:MM:SS"))
return MAXX(t,[avgtime])
If I misunderstood you, could you please offer me more information about your data structure or share your pbix file if possible?
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/zj2u6ngxer3yica/Average%20Time%20per%20Item%20Code.pbix?dl=0
Regards,
Daniel He
Hi AaronRogers3,
Based on my test, you could refer to below steps:
1.I have entered some sample data:
2.Create a new measure and a Table visual and now you could get the average times for per Item Code.
A = var t = SUMMARIZE('Sheet3',Sheet3[ID],"avgtime",FORMAT(AVERAGE(Sheet3[Cleaningtime]),"HH:MM:SS"))
return MAXX(t,[avgtime])
If I misunderstood you, could you please offer me more information about your data structure or share your pbix file if possible?
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/zj2u6ngxer3yica/Average%20Time%20per%20Item%20Code.pbix?dl=0
Regards,
Daniel He
Seems to be working fine and is what i need!
Thanks :)
