Creating a Custom column based on Value from one column

[Anonymous]

Hi Guys,

I am just starting off in Power BI, i have following query.

I want to create custom column based on the values in another coumn of the same table.

For example, if Orignal Column contains value ABC cont or ABC Holding  then it should come to custom column as ABC ans so on for other values in original column who meets the criteria.

Original Column	Custom Group
ele Healthcare	EST
HIGHNESS	PAH
PAH	PAH
ABC Cont	ABC
ABC Holding	ABC
EST Holding	EST

Regards

[suparnababu8]

Hi @Anonymous 

I think for first two rows, it's not possible in Power BI. If we exclude first two rows, then we can do it by using Power Query Editor.

There is option called Column from examples.  If you use that, you'll get the expected out put. 
Step-1

Select the  Original Column->Addcolumn in top ribbon bar->Click on column from examples(highlighted in yellow)

Step-2
After clicking on column from examples you able to see below picture

If you type first 3 letter, then hit enter button, you'll get automaticall all values as expected. Then click ok on above the first characters column.

Step-3

The just you'll rename the  first characters column as Custom Group.

Thanks!

[NHarington · Accepted solution]

Hello, 

By creating a custom column in powerBI and pasting the following dax query, you will return what you are looking for. (Note that you will need to add more rows for each of your conditions. 

NewColumn =
SWITCH(
    TRUE(),
    SEARCH("ABC", [OriginalColumn], 1, 0) > 0, "ABC",
    SEARCH("EST", [OriginalColumn], 1, 0) > 0, "EST",
    BLANK()  -- Or you can add another condition here if needed by simply repeating the above lines
)

 Please mark my answer as the solution if this works for you, feel free to respond if you need more clarification!

Have a great day

[Shivu-2000]

Hi @Anonymous 

For last 4 entry according to your table you can use.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example

https://www.youtube.com/watch?v=BSmmNgO_EOU

And I didnt understand your requirement for starting 2 entries like whats the relation, Can you explain those.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!

[Anonymous]

Hi thanks for reply

Acyually the first coloumn (original coloumn) is company name and second coulmn (custom column) is group name. 

i want build a custom coulumn based on which compnay falls under which group.

Thanks