Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.