Time Zone update with Dax

Good day team,

Hoping someone can point me in the right direction. I am looking to create a DAX measure to convert UTC time to Local time by Market. We are trying to track weather a call was submitted on the same day it started. Currently its converted to UTC in our model and i would like to convert it back to local time. Power Query is not available so i am forced to work with DAX. Below is a snap shot if the table

image

1 Like

Try with

LocalTime = [UTCTime] + TIME(Market[TimeOffsetHours], 0, 0)

1 Like