Forum Discussion
Helper IIConvert 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 an additional column "Convert UTC to Local Time with Daylight Savings Support "
Can anyone help me with this?
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)
3 Replies
- PattemManohar
Community Champion
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
Skilled Sharer
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)
siva3012Hi,
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?
