UTC_DateTimeZone = DateTimeZone.UtcNow(),
  UTC_Date         = Date.From(UTC_DateTimeZone), 
  StartSummerTime  = Date.StartOfWeek(#date(Date.Year(UTC_Date), 3, 12), Day.Sunday),
  StartWinterTime  = Date.StartOfWeek(#date(Date.Year(UTC_Date), 11, 5), Day.Sunday),
                                      
  #"Added DTS OFFSET" = Table.AddColumn(#"Renamed columns 1", "DTS Offset", each if Date.From([createdon]) >= StartSummerTime and Date.From([createdon]) < StartWinterTime then 1 else 0),
  #"Added TIME ADJUST" = Table.AddColumn(#"Added DTS OFFSET", "Time Zone Adjustment", each if [Site_Name] = "CA" then 8 else if [Site_Name] = "TX" then 6 else if [Site_Name] = "TN" then 6 else 5, type any),