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, 2019 in Power BI by Nithin
1,225 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, 2019 by Cherukuri
• 33,030 points

Related Questions In Power BI

+1 vote
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
• 52,360 points
1,417 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
• 52,360 points
1,172 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
• 18,570 points
450 views
0 votes
1 answer

To create link visual in Power BI

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

answered Nov 22, 2018 in Power BI by Upasana
• 8,620 points
632 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,160 points
5,836 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,160 points
3,789 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
4,207 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,490 points
1,555 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, 2019 in Power BI by anonymous
• 33,030 points
1,720 views
0 votes
3 answers

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

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,910 points
53,505 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP