Convert Unix Timestamp to DateTime in Power Query M

Notes

If your timestamps are in milliseconds instead of seconds, divide [UnixTimestamp] by 1000 first.

Requirements

• A number column holding Unix epoch timestamps in seconds.

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 UTC to Local TimeShifts a UTC datetime value by a fixed offset to display it in a specific local time zone.
• Convert Excel Serial Number to DateConverts an Excel date serial number (like 45000) stored as a number into a real Date value.
• Date from Year-Month TextConverts a YYYY-MM text value into the first day of that month as a real Date.
• 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.

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 Unix Timestamp to DateTime.