Forum Discussion
N7Legend
3 years agoRegular Visitor
Add today date each time data refresh
Hello, I would like to add a column containing the current date each time I update my data on power BI, however I do not want my old data to change date. Exemple: ID DateImport 77484 2...
amitchandak
3 years agoSuper User
N7Legend , Create a new table in power query using enter data only one value
ID
9980
And then add a new column in power query
DateI = DateTime.Date(DateTime.LocalNow())
Then append two tables in the power query
- N7Legend3 years agoRegular Visitor
Unfortunately, this solution update every date every time I refresh data.
Maybe I'm doing something wrong ?