Adding columns from examples
We often need to add new columns based on the structure or values of an already existing column or set of columns. Imagine you want to extract information from an existing column quickly or to concatenate some values by typing an example and then apply an underlying rule to all the values of that column. These scenarios can be easily achieved by building new content by adding columns from examples. In this recipe, we will see how to best leverage this feature.
Getting ready
For this recipe, you need to download the FactInternetSales CSV file.
In this example, we will refer to the C:\Data folder.
How to do it…
Once you open your Power BI Desktop application, you are ready to perform the following steps:
- Click on Get data and select the Text/CSV connector.
- Browse to your local folder where you downloaded the
FactInternetSalesCSV file and open it. The following window with a preview of the data will pop up; click on Transform...
