Combining field values to create an additional field

Question

How to combine field values to create an additional field value in Power BI? (Take any example)

Answer 1

Hi Nithin,

1. Go to Power Query Editor, after selecting required sheets from data source.Click on Add Column tab.

2. Now you can create a new column using conditional column or custom column.

• Custom column allows user definition of creating columns by using formula.
• Conditional column allows user a column based on if else conditions.

3. Using Custom Column. (click on Custom Column, the below dialog box opens)

Enter column name, write formula using the fields required for calculation which are seen on the right of screen, and click on ok.

The new column is created as below.

4. Using Conditional Column. (click on Conditional Column option, the below dialog box opens )

Enter column name, and write the conditions based on which column values are to be created (The values can be string or numeric or a field value ) and click on Ok.

The new field is created as below.

Hope this helps you.