i have a date column with Date & Time & a minute column which is a difference between two time columns. However i would like to add this Minutes to the Date Column and the end result should be
if Date is 6/3/2020 1:30:00
And the Allocated Minutes are 0:03 Minutes
Then, 6/3/2020 1:33:00
Any help to achieve this would be appreciated
Solved! Go to Solution.
You can try change the data type. Does this meet your request?
Thanks for reaching out. However that does not solve my problem. I need the date & time both to be visible and also simply Adding the two columns does not add the minutes to the existing date/TIme.
Write this calculated column formula
Actual Started + Allocated Time
I'm not getting the expected result from the Solution you provided. It adds an additional date instead of adding Minutes.
What i need is the following
Actual Started Date = 1/4/2020 4:40:00
Allocated Time (in Mins) = 00:03:00
Then, the result should be = 1/4/2020 4:43:00
You only need to add the mintute column to datetime column. Is this what you want?
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!