Add the date and time when a record was added

[Anonymous]

Hi, I want to add a date and time when a new record is added to Power BI. My source is from Excel, and I don't have that column in my data source.

[v-xiaotang]

Hi @Anonymous 

Have you solved this problem?

If not, I suggest you to add time column in your datasource, otherwise time function will change the whole column I think.

-

If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate！
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,

Community Support Team _Tang

[Anonymous]

Hi @v-xiaotang  

I have not solved the problem. Is the only option to add a date(time) to the data source?

Regards,

[v-xiaotang]

Hi @Anonymous 

yes, coz the function will change the whole column.

Best Regards,

Community Support Team _Tang

[amitchandak]

@Anonymous , see if DateTime.FixedLocalNow() can help. Add this as new column in power query

[Anonymous]

@amitchandak  Thanks for your reply!
DateTime.FixedLocalNow() gives the exact date-time value for all the rows. When I inserted a new record to the source and refresh it again, The DateTime value changes for all the rows again, not only for the newly inserted rows.