Add today date each time data refresh

[N7Legend]

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	21/03/2023
3343	21/03/2023

Then, when I add data to my source and update on power BI:

ID	DateI
77484	21/03/2023
3343	21/03/2023
9980	25/03/2023

[amitchandak]

@N7Legend , Create a new table in power query using enter data only one value

https://youtu.be/5nE7YGT72kU

ID

9980

And then add a new column in power query

DateI = DateTime.Date(DateTime.LocalNow())

https://youtu.be/6eJWUvzfFAc

Then append two tables in the power query

https://youtu.be/KyXIDInZMxk

[N7Legend]

Unfortunately, this solution update every date every time I refresh data.
Maybe I'm doing something wrong ?