Replace Null values with a current time stamp in datetime column

[Anonymous]

Hi Team,

i am new to power bi. i  ahve a data sets which holds DATETIME column which have some NULL values . which i want to replace with the current time stamp. please help

[Anonymous · Accepted solution]

HI @Anonymous,

I'd like to suggest you use replace value function to directly replace these null value to default value(you can't directly use power query function in the navigation pane), then you can use DateTime.LocalNow function to replace that static value to local DateTime.(replace value will auto changes when local datetime changes)

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , In Data transformation you have the option to replace value try that or create a new column in dax like this

https://yodalearning.com/tutorials/learn-how-replace-values-power-query/

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

DAX

New column= if(isblank([datetime]),now(),[datetime])

OR

New column= coalesce([datetime],now())

[az38]

Hi @Anonymous 

create a new column

Column = IF(ISBLANK(Table[datetime]), NOW(), Table[datetime])

or a custom column in power query editor

= if [datetime] = null then DateTime.LocalNow() else [datetime]