Display UTC datetime in client's local timezone

[nwrong]

In my dataset, I've got datetime values stored in UTC. I need to display it in the client's local time. Is there a way to for reports published to the service to display the UTC datetime in my client's local time zone? Clients are spread across multiple timezones.

[TomMartens · Accepted solution]

Hey @nwrong ,

unfortunately, this is not possible.

But maybe you might consider this idea.

Create a table, that contains the user and their offset in accordance with UTC. Then you can use the USERNAME() function to retrieve the current user and use this inside a measure to transform the UTC timestamp into the time of the user.

Regards,

Tom

[nwrong]

Thanks Tom,

that is a good alternative. I'll give it a go.