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
14 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
• 17,870 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
• 37,430 points
81 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
• 37,430 points
28 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,080 points
17 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,490 points
33 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
221 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
122 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
111 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,250 points
91 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
• 17,870 points
15 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
• 17,870 points
76 views