Skip to main content

    Power BI

    Completed

    TODAY () function when I add a custom column

    Vote (1) Share
    Casey's profile image

    Casey on 09 Jul 2016 02:24:51

    Administrator on 09 Jul 2016 03:24:15

    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 () )

    Comments (2)
    Casey's profile image Profile Picture

    735f0507 9f36-4538-b5d1-db5e15b8207f on 06 Jul 2020 00:15:29

    RE: TODAY () function when I add a custom column

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

    Casey's profile image Profile Picture

    b5f5b304 ca8c-4f3b-8ddf-636f7e971a19 on 05 Jul 2020 23:09:10

    RE: TODAY () function when I add a custom column

    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...