Forum Discussion
change duration format to decimal
Hello
I am new to PowerBI and I added a custom column to calulate time with the following formula :
if [#"Priority Rating (DVP)"] = "Critical" and DateTime.Date( DateTime.LocalNow() )-[First Seen] <= 30 then "Within SLA" else "Outside SLA"
| Priority Rating (DVP) | First Seen | SLA |
| Critical | 7/11/2024 | Error |
| Critical | 8/15/2024 | Error |
And I get a "error" in the "SLA" column like this:
Expression.Error: We cannot apply operator < to types Number and Duration.
Details:
Operator=<
Left=30
Right=47.00:00:00
Can I include in the formula above the option to automatically convert the result expressed in duration into decimal instead of returning "error"? thanks.
the problem is for the below condition
DateTime.Date( DateTime.LocalNow() )-[First Seen] <= 30
in the left site of <= we have duration format in the right side we have number, change the number to duration by using #duration(30,0,0,0).
I also recomended to use the below formula for this part in some cases your format might be mismatch.
(Date.From( DateTime.LocalNow() )-Date.From([First Seen])) <= #duration(30,0,0,0)
3 Replies
the problem is for the below condition
DateTime.Date( DateTime.LocalNow() )-[First Seen] <= 30
in the left site of <= we have duration format in the right side we have number, change the number to duration by using #duration(30,0,0,0).
I also recomended to use the below formula for this part in some cases your format might be mismatch.
(Date.From( DateTime.LocalNow() )-Date.From([First Seen])) <= #duration(30,0,0,0)Your welcome,
if it solve your problem, pls mark it as solution for the use of other users.