Forum Discussion
How to display Total Time/Duration in a matrix
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,
- Anonymous7 years agoNot applicable
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:.
- Anonymous7 years agoNot applicable
Hello v-jiascu-msft ,
Thanks for the help so far!
I have accomplished to use the DAX-Code out of "Addition-of-time-in-a-day. " 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.
Besides my apologies for my English, I am not a native speaker.
- v-jiascu-msft7 years ago
Microsoft Employee
Hi Anonymous ,
Can you share some snapshots or the file, please? Please mask the sensitive parts first.
Which visual did you add it to? I'm afraid it can't work in some visuals because it's a TEXT format value.
Best Regards,