Forum Discussion
Sum duration column and display in chart
Dear Power BI Experts, I have edited my Time Gap column to duration type but I am unable to sum the duration column in my desktop. There is only count function available, is there anything i have...
HI Anonymous,
AFAIK, power bi data model tables do not support duration types and you cant use these types which are not support summarized on chart value fields. (date/time and durations types cannot be aggregate)
For this scenario, I'd like to suggest you convert them to 'total seconds' in whole number type. Then you can simply use them on visual value fields and they will be auto aggregated.
Regards,
Xiaoxin Sheng
community_pinki
Helper II
Helper IIHi Anonymous ,
You cannot take a sum of TimeGap column as it is not a numerical value type column So there's only option to take count and distinct count.