How to add custom column to query that populates today's date?

[Anonymous]

I want to create a custom column in a load query that reflects the date the data was loaded, but when attempting to use Today() or Now() an error is returned. How should this be done?

[Greg_Deckler]

In the query, create a new column and use

DateTime.LocalNow()

From:

https://support.office.com/en-us/article/DateTime-LocalNow-Applies-to-Power-Query-567827c0-d7d8-441b...

In DAX, use:

=TODAY()

Of course, that would be a bad idea to use TODAY() in DAX for what you want, as I am sure you have already realized.

[desertislesql]

How to create a column containing today's date depends on the source of the query.  If the query is from SQL Server the query would be something like Select column1, getdate() as Loaddate from tableY