Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
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.
Hi,
See this
Hi @Shakeerm
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!
Hi,
Write this calculated column formula
Actual Started + Allocated Time
Hi Ashish
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
Hi,
See this
You only need to add the mintute column to datetime column. Is this what you want?
Proud to be a Super User!
You can try change the data type. Does this meet your request?
Proud to be a Super User!
Hey Ryan
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |