Forum Discussion
BICrazy
Helper II
Helper IIDrop Seconds from Duration Measure
Hi, I'm very new to this forum and still a basic learner of Power BI. I'm using the following 2 measures to display Duration as Hours minutes and seconds. 1st Measure: Duration2Seconds = V...
BICrazy ok no worries, however the second script i posted does work.
BICrazyHelper II
Helper II
Thanks for all your assistance. I initially thought that I was doing something wrong.
I've managed to convert the duration to hours and minutes by removing seconds from the return on the 1st Measure. This drops the overall time but I figured that I'm dropping all the seconds from each individual record in my data which was adding up to minutes.
vanessafvg
Community Champion
Community ChampionBICrazy ok no worries, however the second script i posted does work.