Unable to summarize TIME

[Anonymous]

Hi

I'm trying to summarize a column which has a time in every cell (hh.mm.ss). Usually to summarize column I just use "=SUM("COLUMN")" and that works. Fro whatever reason I'm unable to sum time. Tried even to use raw data in my visualisation and then chose to SUM the values but SUM option does not appear in there as well. Column is formated in TIME so no issue there. I have created a measure with SUM function on the neighbouring next two columns and data is correct. 

[ppm1 · Accepted solution]

Please see this article for a good way to summarize and format durations.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[Anonymous]

Hi @Ritaf1983 

Thanks for your response. I did tried the duration and that did not solve the problem 100%. I would be more than happy to elaborate via teams and share live feed of the issue but some of the Info is for internal purposes only hence not too happy to sample it out "In to the wild" 😉

WOuld it be posibe to have sort of Teams Call?

Kind Regards

Michal

[Ritaf1983]

Hi, Michal.
I'm afraid my Spoken English is not good enough to have an intelligent conversation without stuttering 😂.
Share the file and we can still try to assist 🙂

[Ritaf1983]

Hi @Anonymous 
Is your Data type "duration"?
if not, just modify it from "time" to "duration".
in another case 
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.