Forum Discussion
Unable to summarize TIME
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.
Please see this article for a good way to summarize and format durations.
Calculate and Format Durations in DAX – Hoosier BI
Pat
4 Replies
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.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
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 🙂
Please see this article for a good way to summarize and format durations.
Calculate and Format Durations in DAX – Hoosier BI
Pat
