Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |