title: Timezone changes in Power BI
body: <p>We have a team that currently resides in the <code>US</code> and <code>Poland</code>. Due to time changes, the &quot;<code>excused</code>&quot; login time is incorrect for <code>Krakow</code> because some analysts start around <code>11 pm Poland time</code>, and the system picks up that they logged in at <code>12am</code> the next day US time.</p>
  <p>This is currently what I have written:</p>
  <pre><code>  SELECT 
           UPPER([UTL_REFERENCE]) as userid,
           CONVERT(date, schedule. dia) as date,
           schedule.dia as scheduled,
           schedule.Excused 
      FROM 
      (
         SELECT 
            MIN( HORT_DATE + CAST(cast(HORT_HEURE_DEBUT as time) as datetime)) as dia, 
            CONVERT(date, HORT_DATE) as the_day, 
            HORT_XRF_REP_SEQUENCE,
            Excused = 
             CASE 
               WHEN (HORT_CODE_ACTIVITE = 13 and HORT_ID_RESTRICTION = 32) then 1 else 0 
             end 
          FROM [CWFM].[dbo].[CalHorairesxJourxPrepose] chj
          where  
            HORT_CODE_ACTIVITE IN (4, 13,17) and 
            HORT_DATE &gt; '2019-01-01 00:00:00'
          group by CONVERT(date,HORT_DATE), HORT_XRF_REP_SEQUENCE,
             CASE 
               WHEN (HORT_CODE_ACTIVITE = 13 and HORT_ID_RESTRICTION = 32) then 1 
               else 0 
             end 
       ) schedule 
  
  inner join [CWFM].[dbo].CalPreposes cp 
      on cp.REP_SEQUENCE = schedule.HORT_XRF_REP_SEQUENCE
  inner join [CWFM].[dbo].[CalProfilUtilisateurs] cpu 
      on cp.REP_SEQUENCE = cpu.[UTL_XRF_REP_SEQUENCE]
  where cp.REP_ACTIF = 1
  </code></pre>