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.com/PacktPublishing/DAX-Cookbook/tree/master/Chapter03.
  2. Use an Enter Data query to create a table called R09_Table with the following data:

Time

Timezone

1:00:00 PM

EST
  1. Ensure that the data type for the Time column is set to Time.
  2. Create a relationship between the Timezone column in the R09_Table table and the Abbr. column in the R09_Timezones table.