Forum Discussion
New Column guidance
Community ChampionTheoretically you should just be able to add/subtract your time values, right?
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?
- Greg_Deckler
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.
Would I need to generate tables for hours, minutes and seconds?
- amitchandak
Super User
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
