Apply TimeZone offset from offset table to datetime table with snowflake schema

I have a Snowflake Schema setup where I have a main Ticket table which is connected to a DateTime table.  Then in order for me to see what timezone the records are in I need to connect to a Call Center Table which is then connected to the TimeZone offset table.  How can I set this up so that I can apply the appropriate timezone offset to the datetime table?

I've tried creating calculated columns that work with these but everything I try fails.  

EDIT:  

I have tried different methods  to achieve this with some success in finding a work around but none in auto assigning a timezone.  Below is an update I put as a reply in this post.  I've modified my original ask as well.

I am working with a Apps Own Data embedded setup for Power BI.  The semantic model is an import model coming from databricks.  

The model is also now setup as  a star schema.  

Below is some fake data.  The data comes into our system as EST.  I would like to be able to pass the timezone offset from javascript via embedded and auto setup the timezone the user sees.  

I have tried the following measures with no success (as they keep timing out).  A user may create a table visual with thousands of rows in it with their datetimes laid out in it. 

I hardcoded the -3 below just to try to convert to PST from EST.

AdjustedCreateDateTime = 
    CALCULATE(
        MAX('CreateDateTime'[CreateDateTime]) + -3/ 24
    )

Fact Table

CreateDateTime