Combining field values to create an additional field?

0 votes

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

Mar 8 in Power BI by Nithin
22 views

1 answer to this question.

0 votes

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.

answered Mar 8 by Cherukuri
• 25,900 points

Related Questions In Power BI

0 votes
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 40,460 points
110 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 40,460 points
39 views
0 votes
1 answer

Convert an expression from SQL to Power BI

Use the following expression: MyTemperatureTable = FILTER ( Device1234, ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 14,070 points
22 views
0 votes
1 answer

To create link visual in Power BI

You can disable sandboxing by adding this ...READ MORE

answered Nov 21, 2018 in Power BI by Upasana
• 8,530 points
40 views
0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,190 points
357 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,190 points
196 views
0 votes
1 answer

How can I search for multiple strings?

A simple solution is this: List.ContainsAny(Text.SplitAny("This is a test ...READ MORE

answered Oct 24, 2018 in Power BI by Upasana
• 160 points
149 views
0 votes
1 answer

Power Query Web request results in “CR must be followed by LF” Error

What I think is, it might look ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,290 points
148 views
0 votes
1 answer

Give constant values to a column or field

Hi Priyanka, You can use a measure to ...READ MORE

answered May 17 in Power BI by anonymous
• 25,900 points
24 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 25,900 points
135 views