Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to display Total Time/Duration in a matrix

Hello,  Currently I want to show duration in a matrix in Power BI Desktop. I have accomplished to show duration as time in the matrix, which suffice.   However the totals in the matrix are not c...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous ,

 

Since there isn't a data type like Duration, we can't add the time directly for now. For example, 100:23:50 is a duration format rather than a time format. There is a workaround. Please refer to Addition-of-time-in-a-day.

 

 

Best Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello v-jiascu-msft ,

 

Thanks for the help so far!

 

I have accomplished to use your DAX-Code and insert DAX language for showing the days.

 

However my Code won't work, because of the days I think.

If I use "... return days & "." & hours & ":" & minutes & ":" & seconds)", I get a note that the visualization won't open. And if I use "... return days & " " & hours & "" & minutes & "" & seconds)", the visualization will show, but I get a decimal number. 

 

So my question is what I should do if I want to show the duration of an activity. When an activity has cost several days and I want to show days.hours:minutes:seconds.

 

I hope you can help me and again thanks for the help so far. Besides my apologies for my English, I'm not a native speaker:smileyvery-happy:.