Convert UTC time to UK Time ?

[siva3012]

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?

[siva3012]

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?

[PattemManohar · Accepted solution]

@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]

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)