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
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.
Any advice please?
Kind regards,
Malan
Solved! Go to Solution.
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.
And later replacing the #time( 0, 0, 0 ) in your Replaced Error Step with your expression, like below
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.
And later replacing the #time( 0, 0, 0 ) in your Replaced Error Step with your expression, like below