Automatically setting todays date in query

[Redlad1291]

Hi,

I currently have a table set up with a query where the date has to be changed manually every month i update it, What i want to do is get this to manually adjust everytime i refresh the data.

The query i currently have is:

= Table.AddColumn(#"Expanded Period Table", "Custom", each "11/01/2019")

is there a forumla or a way to adapt this query so it just updates whenever i refresh the data in BI?

[Greg_Deckler · Accepted solution]

I believe what you want is:

= Table.AddColumn(#"Expanded Period Table", "Custom", each DateTime.LocalNow() )