Forum Discussion
RIDWIV
Helper I
3 years agoAddition of time from multiple column
Hello @all, I want to add timestamp from different olumn and get the exact result. Any idea how it c
Anonymous
3 years agoNot applicable
I would convert to number, then do the addition. Then convert back to time.
--Nate
- RIDWIV3 years ago
Helper I
Anonymous sorry it did not worked and also time addition is different.....once it reaches to 60 it itself convert to 1 hour
- ppm13 years ago
Solution Sage
Please see this article. You can convert all your time columns to decimal, do your math in a measure, and then format it at the end.
Calculate and Format Durations in DAX – Hoosier BI
Pat