The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Dear All,
I'm tryning to find the way to get a report that allow me te see the average of time data.
This my data :
This is My expectation from Power BI but done with excel :
In Power BI, I'm not able to see the Time value.
Many thanks for you Help
BR,
See my blog article here:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Basically, you will need to convert it to seconds, there is no true duration type in Power BI. But you can vote for the Idea here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type