How to Sum Hours, Minutes, and Seconds with DAX in Power BI [h:nn:ss] - Part 2

In this lesson, I'll show you how to sum hours, minutes, and seconds with DAX in Power BI.

___________
Highly recommended Power BI books (Affiliate links):

___________Relevant PBI Topics
____________

[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.

___________For more tips, follow me on:

Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!

#DAX #PowerBIDAX #vizxlization #hhmmss

[MichaelShannon-yvtv]

Thanks Nestor...This is exactly what I needed for duration values for call records. CHEERS!!!

[RachelSirois]

Thank you! I was able to modify the code to show hh:mm as needed for my matrix

[robindellsurilla]

Please make a tutorial of two different tables to calculate the difference of the time. Thank you!

[yogeshsinhkhebde]

can we never - ever make a text time to be converted into a value ?

i have a data with column total of 360000 seconds and I want it to be displayed as "100:00:00" as a hours value ... not as text... because I have a scroller visual wich does not accept any text as an input for 'measure absolute' parameter. can you help me crack it too ?

[pkchannel]

we can do it with the help of power query but format not remains same and unable to make format again report view same as power query.

[pkchannel]

I have two dates i want to calculate D.HH.MM.SS with two dates so how we can calculate
For Example 3/12/2024 4:00:00PM and other 3/13/2024 8:00:00PM

I need answer in this format 1 Day : 4:hours:00:00
Please help on this.

[joshuasolano]

It's missing the export data and the transform data part of the power BI. I always get "12:01:00 am" as time in Excel to Power BI instead of just 00:01:00 for duration

[AbigailMartinez-mw]

What if the hours go up to 3 digits? Will this formula work? I have some times that go up to 700 hours.

[BenedictMthombothi]

I'm struggling to use the same if there are months between the dates, I'm not getting correct days. Like I woould expect 40days, 2hours, 20min, 10Sec

[alivirk]

can you explain how you write formula in hours minutes and second column

[aliaziz]

how can we make difference from two different table and between two columns row by row if both have same order id
TableA TableB Difference
ID column timestamp column ID column Timestamp column days hours minutes
Kindly make video on it Dear

[rodrigohernandez]

super great video! thanks!
Just one question.
Is there any way to use that same measure to visualize the data on a chart?
For example I wanted to see the sum of that time but by month or by week.
It does work on a matrix but not on a barchart or a line chart. When I add the measure to the axis nothing happens, it just stays blank.

Thanks!!

[prasanthkumarmaturi]

Hey hello im prasanth i used your DAX formula it came but im unable show in graphs. Will you explain why what to do show in charts
Please tell its very important to my project and job

[ganeshankush]

Hello Nestor but it is showing into text format, how convert it into time format?

[annaboinaanil]

Hi nestor, if you possible pl explain, how to total net average hours, minutes, and second with dax in power bi

[JawnNawva]

How can you rank these times? are you able to rank by distinct times?
1 | 20:15:00
2 | 19:14:23
3 | 10:39:00

[seepanameghana]

Hi, if we want to find time duration between two columns

[annaboinaanil]

I need average net hours and minutes and seconds

[NestorAdrianzen]

Do you know a different way to solve that question? Let me know by leaving a comment below👇 Cheers

[madalinmd]

This can't be true, to be so hard to sum duration in PBI, what? :|