Convert UTC to Local Time in Power Query M

Notes

Change the -5 hour offset to match your target time zone; this doesn't automatically adjust for daylight saving.

Requirements

• A datetime column stored in UTC.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Convert Unix Timestamp to DateTimeConverts a Unix epoch timestamp (seconds since 1970-01-01) into a proper DateTime value.
• Generate a Date TableBuilds a continuous calendar table between two dates with year, month and quarter columns.
• Fiscal Calendar with Custom Start MonthBuilds a calendar table where the fiscal year and fiscal month are calculated from a custom fiscal year start month instead of January.
• Time Table (Hour and Minute Buckets)Generates a standalone table of every minute in a day, useful for time-of-day analysis and slicers.
• Business Days Between Two DatesCalculates the number of weekdays (Monday-Friday) between two dates, excluding weekends.
• Date Table with Working Day / Weekend FlagAdds a boolean column to a date table marking Saturdays and Sundays as non-working days.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Convert UTC to Local Time.