Tinkering with time zones

Ah, time zones. Such a simple concept that has caused so much havoc in the world of software development through the years! There are no functions in DAX that really address time zones, but it is often a requirement to convert date and timestamps in one time zone into date and timestamps in a different time zone. This can be especially true when dealing with log files as a data source. This recipe demonstrates how to convert date and timestamps in one time zone into date and timestamps in a different time zone.

Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop and create a table called R09_Timezones by importing the Timezones.csv file from GitHub here: https://github...