ADD A COLUMN WITH A SPECIFIC DATE

[MS3]

Hello!

Very stupid question. Seems super simple, but cannot find the solution. Just trying to add a date manually into a column in a table. All I need to add is a column with a specific date (e.g. 31/Dec/2019) which will have the same value in all the column.

I try adding a custom column but it does not recognize the DATE function, neither does it recognize a simple =DD.MM.YYYY

Thanks!

[MS3]

Many thanks! Works perfectly!

MS3

[Greg_Deckler]

Great! Glad to hear it!

[Greg_Deckler · Accepted solution]

In DAX,

DATE(2019,12,31)

In Power Query, I would just do something like:

="12/31/2019"

And then just convert the column to be a date.

[ADN75]

It works, thank you for your help 🙂