Forum Discussion
how to parse duration
Anonymous , please check if these can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Hi Anonymous,
In my opinion, I'd like to suggest you split duration type value into multiple fields to store different units or transform them into one level (e.g. total seconds), it should help for the Dax calculations. You can simply create a text field with DAX formulas to show the raw duration values. (notice: raw duration type not supported in power bi data mode tables)
Regards,
Xiaoxin Sheng
Super UserAnonymous , please check if these can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
AdministratorUsing the Chelsie Eiden's Duration in this post I was able to arrive at the sum of the hours in Power BI (step 1). The issue is that I don't have as instead of the sum being able to use the average time.
Do you know if there's a way to do it?
- Syndicate_Admin
Hello you found the solution also I want to average it