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)

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
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)

  • jcarville's avatar
    jcarville
    Icon for Skilled Sharer rankSkilled Sharer
    6 years ago

    This solution works in desktop but does not work when you publish the report to the service. Any ideas on a fix? (I know the Service goes by UTC time)