Vanduongls86
jongio
/ daxconvertsecondstotime
Created
December 1, 2016 23:33
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Originally from: https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486 | |
| Duration = | |
| // Duration formatting | |
| // * @konstatinos 1/25/2016 | |
| // * Given a number of seconds, returns a format of "hh:mm:ss" | |
| // | |
| // We start with a duration in number of seconds | |
| VAR Duration = [Change this value to the name of your column that contains your seconds value] | |
| // There are 3,600 seconds in an hour | |
| VAR Hours = |