TODAY () function when I add a custom column

It's already possible to dynamically retrieve today's date when authoring a Custom Column in the Query Editor. You can use DateTime.LocalNow () or DateTime.UtcNow () to get a date/time stamp, from which you can extract the date part. Something like this should work: Date.From(DateTime.LocalNow () )

why TODAY () function doesn`t work in Power Query instead of Date.From(DateTime.LocalNow () )? i was tried to do simple TODAY () -[Start Date] an example...

this just shows "function" in the table. how do I get the actual date?