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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Replace values in a time column: Replace errors with "Current Time"

Hi, I am trying to replace error values in a Time column to the "Current Time".  The syntax I suppose should do this, is DateTime.Time(DateTime.LocalNow()).   However, this option doesn't seem to be viable.  Screenshot_1.png

 

 

Any advice please?

 

Kind regards,

Malan

 
1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

 

You can not do it with the UI as it will not accept functions, however, you can do it by:

Replacing Errors with 00:00:00 like below.image.png

And later replacing the #time( 0, 0, 0 ) in your Replaced Error Step with your expression, like belowimage.png
image.png

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

View solution in original post

1 REPLY 1
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

 

You can not do it with the UI as it will not accept functions, however, you can do it by:

Replacing Errors with 00:00:00 like below.image.png

And later replacing the #time( 0, 0, 0 ) in your Replaced Error Step with your expression, like belowimage.png
image.png

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors