Forum Discussion
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 | 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 |
2 Replies
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
Unfortunately, this solution update every date every time I refresh data.
Maybe I'm doing something wrong ?
