Forum Discussion

Gillard_2's avatar
Gillard_2
Frequent Visitor
5 years ago
Solved

Replace errors with Today() or Now()

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

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion

    Those are DAX functions.

    You want 

    DateTime.LocalNow()