Forum Discussion
RIDWIV
3 years agoHelper I
Addition 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
RIDWIV
3 years agoHelper 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 agoSolution 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