Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
caciliberti
New Member

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 SeenSLA
Critical7/11/2024Error
Critical8/15/2024Error

 

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. 

1 ACCEPTED SOLUTION
Omid_Motamedise
Impactful Individual
Impactful Individual

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)

View solution in original post

3 REPLIES 3
Omid_Motamedise
Impactful Individual
Impactful Individual

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)

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

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors