Add a Custom Column Containing Today's Date

[Myerstm]

How do I add a custom column which contains a calculated today's date?

[TERRY_HUGHES]

Date.From(DateTime.LocalNow())

[MarkLaf · Accepted solution]

DAX: TODAY()

M: DateTime.LocalNow()

Note, for M if you want date only you can do Date.From(DateTime.LocalNow())

[OlaKvarnbo]

When I do this all that turns up in my new Custum Column is "Function" and no dates☹️

[MarkLaf]

You are actually referencing the function rather than invoking it currently. You could even drill into your column now and see the metadata for the function.

To invoke the function, which is what you want, add the parentheses at the end: instead of "each DateTime.LocalNow", use "each DateTime.LocalNow()"

[Myerstm]

Hello MarkLaf,

Thank you for your help.  I'm a newbie, just getting started and have a long way to go (as you can tell).  M worked perfectly.

Tim