Forum Discussion

Regular Visitor

7 years ago

Solved

Add a Custom Column Containing Today's Date

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

Tips and Tricks

MarkLaf
7 years ago
DAX: TODAY()

M: DateTime.LocalNow()

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

Super User

7 years ago

M: DateTime.LocalNow()

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

Regular Visitor

3 years ago

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

MarkLaf
Super User
3 years ago
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()"