Unix uses a system of timekeeping called Unix epoch, which is the number of seconds that have elapsed since January 1, 1970 at midnight, not counting leap seconds. This recipe demonstrates how to convert this Unix epoch into a much more readable Coordinated Universal Time (UTC) date/timestamp.
Converting Unix into UTC and back
Getting ready
To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R03_Table with the following data:
- Ensure that the data type for this column is set to Whole Number.
