Solved: Custom column: if a text contains a certain value,... - Page 2

hidenseek9 · ‎09-12-2017

Hello Power BI community,

I have a question regarding a custom column.

In my data set, I have a column with different brand names.

(Nike, Addidas, Reebok, etc.)

In the same dataset, I have another column with sports name.

(Soccer, Basketball, Tennis, etc.)

I would like to create a custom column that will give me

the brand names, but for just Nike,

if the sports is basketball I would like Power BI to return the value, "Nike Basketball".

How can I set up a custom column to get what I want?

Many thanks,

H

Ashish_Mathur · ‎09-12-2017

Hi,

It works well. The formula in the Sport column is

=FIRSTNONBLANK(FILTER(VALUES(eligible_sports[Eligible Sports]),SEARCH(eligible_sports[Eligible Sports],Data[Description],1,0)),1)

The formula in the next column is

=if([Brand]="Nike",[Brand]&" "&[Sport],BLANK())

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Custom column: if a text contains a certain value, then return A