Skip to main content

Issues

New

"Today" in QnA does not use local time?

Vote (1) Share
Greg Nash's profile image

Greg Nash on 10 Nov 2016 08:01:33

When using pinned QnA visualisations we have tested several tiles which use the common workaround to a filter limitation where "Today" is used to filter data only relevant to today.

We are finding this does not show "today's" data until 11am AEST (which happened to be UTC +11)

I suspect "Today" is using UTC time instead of Local time to filter the data

Comments (1)
Greg Nash's profile image Profile Picture

JOE CRONK on 02 Jun 2023 15:17:35

RE: "Today" in QnA does not use local time?

I received a response on this along with some recommendations from Microsoft on how to deal with TODAY() being based on the UTC time of the service server.Summary:• Today() function, returns the current date only in DateTime format. Please note on the Power BI service the time is considered in the UTC zone. On the Desktop, it will be your local time zone, or the server time zone you are connecting to.• The incorrect values could be a result of the Power BI service, as it considers the UTC zone only. To get the date according to your local time zone please update the DAX function in the Power BI Desktop file.• Please check below for the difference in these four functions. NOW: Returns the current date and time in datetime format.TODAY: Returns the current date in datetime format.UTCNOW: Returns the current date and time in datetime format expressed in Coordinated Universal Time (UTC).UTCTODAY: Returns the current date in datetime format expressed in Coordinated Universal Time (UTC).For the Exact timestamp and date, you can use the Now() function and update the time in DAX in the Power BI Desktop file, to reflect in the Power BI Service.For ex: The now () function on the desktop will current the date and time as per the time zone of your local machine.In the Power BI Service, it will show the date and time as per the UTC zone.To show it in your local zone in the Power BI Service, update the DAX in Power BI Desktop: Now() + 5.5/24(for IST)Another important thing to note, is that the +/- to UTC is based on where your organization's tenant is based.https://learn.microsoft.com/en-us/power-bi/admin/service-admin-where-is-my-tenant-located