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
10 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,380 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
• 35,750 points
48 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
• 35,750 points
23 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
13 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
• 7,560 points
28 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
126 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
58 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
70 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
• 12,150 points
60 views
0 votes
1 answer

Give constant values to a column or field

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

answered 5 days ago in Power BI by anonymous
• 13,380 points
5 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
• 13,380 points
58 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.