Forum Discussion
Report Development: Convert the UTC time to Local Time zone based on the user time zone/system time
Hi
I am working on a power bi reports where we try to display the timestamps gathered from an electronic beacons they users are located in different time zone but when the data is being stored in SQL server the data is converted to UTC time so when we are trying to display them back the values should be going back to the local time zone of each user so is there any good way where i can achieve this.
2 Replies
Hi,
If you have data on which beacon belongs to which user, and which user is in which time zone, then you should be able to convert the timezone info for each users into an offset amount compared to UTC, and then offset the timestamps by that.
Beacon TableBeacon Timestamp UTC User 00001 17:00:00 Joe 00002 19:30:00 Adam UserTable
User Time zone UTC Offset (calculated column) Joe Madrid 1 Adam New York -5
If you have your data similar to the above, you should be able to create a calculated column on the beacon table where you look up the offset on the User table, and add it to the UTC time column to get the local time. I hope this makes sense. If not then please provide an example of how your data tables look like so that we can help further.hi dk_dk
I have a table something like thiswhere each organization lies in a different timezone so i need the values to convert the time stamps to there local timezone values is the above method still aplicable and if yes what do i have to next like how to convert multile columns to the local time zones?
