Forum Discussion
Add the date and time when a record was added
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.
amitchandak
Super User
Super UserAnonymous , see if DateTime.FixedLocalNow() can help. Add this as new column in power query
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.