Forum Discussion
Replace Null values with a current time stamp in datetime column
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
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
3 Replies
- az38
Community Champion
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] - amitchandak
Super User
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())
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
