Forum Discussion

siva3012's avatar
siva3012
Icon for Helper II rankHelper II
7 years ago
Solved

Convert UTC time to UK Time ?

Hi,   I need to add additional column by converting UTC Date_Time to UK Date_Time format. During Daylight savings starts, UK Time will be UTC+1 & after it ends it will be UTC.   I need to create ...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    siva3012 Please try something like this...

     

    Change the datatype to Date/Time/Timezone in Power Query Editor and then extract the Timezone difference as well and then add the timezone 

     

     

    Then use the below logic to add time to convert to UK time

     

    UTC_UK = Test162TimeZone[UTC] + TIME(Test162TimeZone[TimeDiff],0,0)

siva3012's avatar
siva3012
Icon for Helper II rankHelper II
7 years ago

Hi,

 

I need to add additional column by converting UTC Date_Time to UK Date_Time format. During Daylight savings starts, UK Time will be UTC+1 & after it ends it will be UTC.

 

I need to create an additional column "Convert UTC to Local Time with Daylight Savings Support " 

 

 

 

 

 

 

 

Can anyone help me with this?