Report Development: Convert the UTC time to Local Time zone based on the user time zone/system time

[Praneeth19]

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.

[Praneeth19]

hi @dk_dk 

I have a table something like this

where 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?

[dk_dk]

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 Table

Beacon	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.