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.
Looking for assistance.
Description of issue:
When deducting duration from Time, after an hour 00.00 and before 00.45, the value is not deducted correctly.
Walkthrough:
Working with columns:
"OpenHoursTo" as text value, eg.
"DeliveryTime" as whole number eg. 15, 45, 0
Purpouse - find the timestamp: OpenHoursTo - DeliveryTime
Step_1: Transform text value of column "OpenHoursTo" to Time, we get eg: 16:00
Step_2: Transform whole number of column "DeliveryTime" to Duration
So if DeliveryTime is 15, transformed value is - 0.00:15:00
Formula used: DeliveryTime = #duration(0,0,0, [DeliveryTime]*60) (NOT SURE IF THIS IS CORRECT)
Result:
As can be seen highkighted values, except the last one, give an incorrect result. Once the clock hits between 00.00 & 00.45, the values are not deducted correctly.
Any ideas how can I fix this issue?
Thanks,
Ed
Solved! Go to Solution.
Hi @Anonymous
You may create a custom column as below:
Custom=[OpenHoursTo]-#duration(0,0,[DeliveryTime],0)
Regards,
Cherie
Hi @Anonymous
You may create a custom column as below:
Custom=[OpenHoursTo]-#duration(0,0,[DeliveryTime],0)
Regards,
Cherie
Worked great, thanks for your help!
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |