Forum Discussion

Praneeth19's avatar
Praneeth19
Frequent Visitor
2 years ago

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 SQ...
Need Help
dk_dk's avatar
dk_dk
Super User
2 years ago

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

BeaconTimestamp UTCUser
0000117:00:00Joe
0000219:30:00Adam

UserTable

UserTime zoneUTC Offset (calculated column)
JoeMadrid1
AdamNew 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.