New Column guidance

Question

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:46:32

I have a column 'Begin Execution Time' that is a time stamp of when the job kicked off - example: 2020-02-17 04:30:03.390

I need to establish an expected start time based on the previous elapsed hours, mins, seconds and the begin execution time.

Thanks so much in advance!

greg_deckler · Answer

Theoretically you should just be able to add/subtract your time values, right?

anonymous · Answer

I tought that as well, but when I converted the column that is hours, mins, seconds to date time it didn't work. Don't they both have to be date/time stamp to add or subtract from each other?&nbsp;

greg_deckler · Answer

Anonymous ah, I missed that one was essentially duration. See if this helps:&nbsp;https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
&nbsp;
And it's update:&nbsp;https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639?search-action-id=101896880406&amp;search-result-uid=793639
&nbsp;
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 · Answer

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

amitchandak · Answer

Can you share sample data and sample output.Thanks. Proud to be a Datanaut My Recent Blog -https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Forum Discussion

New Column guidance

9 Replies

Related content

Guidance Needed on Push Dataset API Retirement

Need Gantt Chart Guidance

Request for Guidance: Sharing Power BI Report with External User

Guidance on Affordable Licensing Options for Power BI Report Server

Map Visual Guidance