change duration format to decimal

[caciliberti]

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. 

[Omid_Motamedise · Accepted solution]

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)

[caciliberti]

This is very helpful, thank you vert much for the help!!

[Omid_Motamedise]

Your welcome, 
if it solve your problem, pls mark it as solution for the use of other users.