Replace errors with Today() or Now()

[Gillard_2]

Hi, Trying to replace errors in power Bi Query in a date/time column with Today but am unable to work out the right formula to do this.

Its currently replacing them with 01/01/2030 in the formula below:

= Table.ReplaceErrorValues(#"Changed Type", {{"End time", #datetime(2030, 1, 1, 0, 0, 0)}})

Please help me re write this to be dynamic and always replace erros with Today() or Now() intead. 

Thanks in advance

[HotChilli · Accepted solution]

Those are DAX functions.

You want 

DateTime.LocalNow()