Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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)
Proud to be a PBI Community Champion
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)
Proud to be a PBI Community Champion
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |