- For creating index, conditional and custom columns: https://powerbitraining.com.au/creating-columns-in-power-bi/
- For creating information and standard columns: https://powerbitraining.com.au/creating-information-custom-and-standard-columns-in-power-bi-power-bi-training-across-australia/
Getting StartedTo get started:
- Click on the Home tab in the ribbon.
- From the External Data section, click on Edit Queries
- Select Edit Queries from the drop-down menu to enter the Query editor.
A new window opens showing the interface for Microsoft Power BI Query Editor.
Power BI allows you to create columns of your choice by providing examples of data manipulations needed on the data. The process of creating columns by example in Power BI using the query editor can be functionally divided into two parts:
- Setting the template to for creating similar column values.
- Extending the template to all values in the column.
Let’s first create a template which will be used as an example to set values for other rows in the column.
To create a template for the column by example:
- Click on Country Table in the Queries Pane.
- Click on Add Column Tab in the Ribbon Menu.
- Click on Column by Example in the General Section.
A pop-up menu appears.
4. Type “United States, New York City” in the first row of Column1.
Extending the template:
Now that the reference value has been set, we have a template to create values for other rows in the column.
5.Click on any blank row of Column1.
Entire Column1 is filled with the values following the same pattern.
6. Click OK.
Data transformation is a process of extracting information from raw data. This is achieved by manipulating the data and creating new columns to bridge the information gap. In this blog post, a step by step guide to create new columns using example in Power BI using the query editor has been discussed.
Are you a data analyst and want to learn more about Power BI?
Why not sign up for Power BI training in Australia. We provide our services in the following regions: