Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
Thanks Tom,
that is a good alternative. I'll give it a go.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |