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'm trying to add duration to start time in order to get the end time using the #duration () function, but seems it doesn't accept decimals as I understand the duration function does account the minutes and seconds 😁.
[StartDateTime]+#duration(0, [#"Duration (Hrs)"], 0, 0)
This is the result:
when Duration type is changed to whole number:
Is there a way to work around this? do I need to break the decimal hours to minutes and seconds???
Solved! Go to Solution.
Hi @Anonymous ,
Try this instead. It converts your decimal hours values to seconds before adding:
[StartDateTime] + #duration(0, 0, 0, [#"Duration (Hrs)"] * 3600)
Pete
Proud to be a Datanaut!
Hi @Anonymous ,
Try this instead. It converts your decimal hours values to seconds before adding:
[StartDateTime] + #duration(0, 0, 0, [#"Duration (Hrs)"] * 3600)
Pete
Proud to be a Datanaut!
No problem, happy to help.
Don't forget to give a thumbs-up on any posts that have helped you 👍
Pete
Proud to be a Datanaut!
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.