NESTED IF CONTAIN A WORD

[Anonymous]

Dear Team

Im Having this table

based on CONDITION, by word filled on CONDITION column. will change RESULT as shown above

how to make it with DAX ??

kinda like

if(search and so on .. 

Thanks

regards

Syaiful

[mussaenda · Accepted solution]

@Anonymous,

If you are looking for nested ifs,

You may take a look at this.

Also, Provide a better sample data. And a clearer explanation.

From what I see from the answers, they all achieved your desired output.

[Anonymous]

THANKS bro

solved

[rainer1]

Hi,

you can use "substitute" like this if your name convention is as you described.

Result = SUBSTITUTE('Table'[Condition];" board";"")

the expected Result is then this as you wish.

The SUBSTITUTE function is case-sensitive further reading

https://docs.microsoft.com/en-us/dax/substitute-function-dax

If I can help you please Mark my answer as the solution.

[Anonymous]

thanks for replying

but not what im looking for .

my real data really different.

i just want to make nested if from contain of a word condition

[rainer1]

Ok,

than you cant try the contains function in an if condition

https://docs.microsoft.com/en-us/dax/contains-function-dax

for further advise i would be helpful to see a snippet of the real data.

[amitchandak]

if(search("White Borad",table[col])>0,"White",search("Black Borad",table[col])>0,"Black","Others"))

Refer SWITCH

https://community.powerbi.com/t5/Desktop/Help-with-SWITCH-TRUE-with-multiple-items-to-evaluate/td-p/...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

FAILED bro

[v-yiruan-msft]

Hi @Anonymous ,

I want to ask if the values of column “CONDITION” always end with " boarding " characters ? Or it will display in other forms ? If it always ends with " boarding " , you can create a calculated column with SUBSTITUTE function to get the result value as @rainer1 provided.

RESULT = SUBSTITUTE('TEST4'[CONDITION]," board","")

https://docs.microsoft.com/en-us/dax/substitute-function-dax 

If it will display in another forms , you may need to provide more sample data, later check if there is any method to achieve it.

Best Regards

Rena

[Anonymous]

Different bro

let say ,,

white board bird

black board cat

red board eagle

that why i said , SUBSTITUE cant solve my problem

any idea ??

im stuck on this

thanks

syaiful

[Adamtall]

Hi,

you ca do a split in powerquery.

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/