Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
HI,
i have a report which gives start date and time also hours to complete. How do I add a new column which gives me the end date and time based on these two columns?
I have tried a custom column with duration and all it does is returns an error. The result needs to show the date and time 10 hours later that the creation date.
Thanks
Solved! Go to Solution.
Hi, please do this as a calculated column:
NewDateTimeColumn = DateTimeColumn + TIME(TimeToResolution/Cancellation (Hours), 0, 0)
Thank you - it gives an end date but not a time. But it will work for what I need I beleive.
Hi, please do this as a calculated column:
NewDateTimeColumn = DateTimeColumn + TIME(TimeToResolution/Cancellation (Hours), 0, 0)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
58 |