Skip to main content

    Power BI

    Needs Votes

    Allow setting of locale and time zone such that DAX functions NOW and TODAY procuce correct local values rather than those from the US

    Vote (10) Share
    Jack Horlock's profile image

    Jack Horlock on 18 Mar 2016 07:00:52

    If you reference a generated date from 'NOW' or 'TODAY' to use in a DAX command to manipulate a date the value genrated is local to the United States not you the users location; New Zealand in my case. this means that age calcuations or relative day calculations are based on a period which is almost from midday to midday rather that midnight!

    Comments (1)
    Jack Horlock's profile image Profile Picture

    Scott on 05 Jul 2020 22:37:36

    RE: Allow setting of locale and time zone such that DAX functions NOW and TODAY procuce correct local values rather than those from the US

    I think it's UTC/GMT time rather than US time, but yes - would be a welcome improvement (I'm in NZ also), although rather unlikely I'm guessing :-(