Splitting a column by delimiter

One of the most common transformation steps in Power Query is Split Column by Delimiter. There are many use cases for this transformation. The following are some of the use cases:

• Splitting First Name, Middle Name, and Last Name from a Full Name column
• Splitting date, time, and time zone elements from DateTimeZone values into separate columns
• Splitting comma-delimited values into separate columns

Let us move forward with a scenario. In the previous section’s scenario, we converted the OrderDateTime column’s type to Date. In this scenario, the business needs to analyze the Internet Sales data at both the Date and Time levels. There are many techniques we can use to satisfy this new requirement, such as the following:

• Creating a new Time table, which can be done either using DAX (we discussed this in Chapter 2, Data Analysis eXpressions and Data Modeling, in the Creating a Time dimension with DAX...