Duplicating a column

Another common transformation step under the Add Column tab is duplicating a column. In many scenarios, we want to duplicate a column, such as keeping the original column available in our model while needing to transform it into a new column. Let us revisit the scenario that we looked at earlier in this chapter in the Splitting a column by delimiter section. In that scenario, we split the OrderDateTime column from the Internet Sales table into two columns, Order Date and Order Time. In this section, we do the same thing, but this time we duplicate the OrderDateTime column instead of splitting it. We use the Chapter 5, Common Data Preparation Steps, Fixed PostCode.pbix sample file that can be downloaded from here: https://github.com/PacktPublishing/Expert-Data-Modeling-with-Power-BI-Second-Edition/blob/main/Samples/Chapter%2005/Chapter%205,%20Common%20Data%20Preparation%20Steps,%20Fixed%20PostCode.pbix.

After opening the sample file, open Power Query Editor...