Forum Discussion
Gillard_2
5 years agoFrequent Visitor
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
Those are DAX functions.
You want
DateTime.LocalNow()
1 Reply
- HotChilliCommunity Champion
Those are DAX functions.
You want
DateTime.LocalNow()