Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New Column guidance

I'm working on a dashboard using a gauge and need to accommodate a scenario in which a job doens't kick off. I have a column 'Expected Run Time' that is elapsed hours, mins, seconds -  example: 02:4...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous ah, I missed that one was essentially duration. See if this helps: https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx

 

And it's update: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639?search-action-id=101896880406&search-result-uid=793639

 

You'll probably have to parse out the hours, minutes and seconds from your duration and figure out how many seconds it is and then add that to your datetime value.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Would I need to generate tables for hours, minutes and seconds? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago


      BeginExecutionTime          EndExecutionTime             RunTime   ExpctdRunTime   AvgRunTime
      2020-02-17 04:30:00.127   2020-02-17 07:32:04.497   03:02:04   10:00:00              03:39:11
      2020-02-17 04:00:00.237   2020-02-17 04:02:18.260   00:02:18   10:00:00              00:03:41
      2020-02-17 04:30:03.390   2020-02-17 06:46:18.747   02:16:13   02:46:32              02:45:05
      2020-02-17 04:30:02.970   2020-02-17 04:30:32.343   00:00:28   00:00:30              00:00:30
      2020-02-17 06:46:19.217   2020-02-17 07:32:04.450   00:45:45   00:47:41              00:47:35