If text column CONTAINS specified value, give me what I want

[BKnecht]

Hi Everyone,

I'm trying to create a calculated column in one of my tables that says:

IF( row CONTAINS "A", put "A", otherwise put "B")

The problem is I can't figure out what the contains function is in DAX, and I've looked everywhere. Can anyone help me out?

Thanks in advance.

[DolEgon22]

Love this solution:

if Text.Contains([ColumnName], "A") then "A" else "B"

However, what if I have more than two possibilities?

For example, ColumnA can be "Car", "Truck", "Bus". How would I create a column that would give a value of "1" for "Car", "2" for "Truck" and "3" for "Bus"?

[satish]

I think the expression was written wrong. 

it should be 

CustomColumn = IF(
	ISERROR(
		SEARCH("A", TableName[ColumnName])
	),
	"B",
	"A"
)

 Or

CustomColumn = IF(
	IFERROR(
		SEARCH("A", TableName[ColumnName])
	, -1) > -1,
	"A",
	"B"
)

Please correct me if I am wrong.

[chwolf]

I need a formua to create a new column that checks a exising column in a table and provides a new value based on multiple condtions.

The formula shall find specified text contained in a longer text string, the searched text can be at the beginning the end or the end of the string.

If the searched text combination is identified, a new text should be put in the new column field.

Logic:

 check field if somewhere in the text string  "*abc* " is contained

         if contained, put "xyz"

         if not contained

         check if  " *def* " is contained, if contained, put "*ufw*" in the new colums

if non of the searched combinations is identified, put "hij" in the new column

many thanks!!

[Ashish_Mathur]

Hi,

Given the data below, i wrote the following calculated column formula in the first Table.  You may download my solution workbook from here.

=LOOKUPVALUE(keywords[Result],keywords[Keywords],FIRSTNONBLANK(FILTER(VALUES(keywords[Keywords]),SEARCH(keywords[Keywords],Data[Data],1,0)),1))

[Anonymous]

I solved a similar scenario with the help of nested IF and OR

RANK = IF(OR(STUDENT[GRADETYPE] = "VERY GOOD", STUDENT[GRADETYPE] = "GOOD"),"One" , "Two")

[KHorseman]

@satish I think you're right. Looks like I got A and B backwards. But I'd go with your first suggestion. IFERROR introduces unnecessary complexity to the formula in my opinion.

[satish]

IFERROR does add complexity.

In my case I had  multiple conditions combined so I had to use IFERROR and I thought someone else might it need it too.  

[KHorseman]

@satish yeah, definitely never hurts to have an alternative method for similar cases.

[Anonymous]

Hello 

Is there a similar DAX to search for Text within different tables? 

Thanks 

[BKnecht]

I had to nest it a few times -  that worked perfectly. Thanks for being so specific with the code too, that really helped. Much appreciated!