powerbi - How can I write DAX to aggregate total time?

Question

I have time format in text as a table in Power bi.

I want to find total duration of time by adding all time together in days, hours, minutes, seconds

How can I write Dax for this?

Thanks in advance!!

标签： powerbidax

Answer 1

是的，时间列中的时间不能超过 23:59:59，不存在任何更大的时间，最好将元素转换为天、小时、分钟、秒。按分隔符分割