Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@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
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |