Add a calculated column based in an agregation of values in other columns

[simaotc]

Hello community,

I have a table like the example below.

I would like to add the code if any column in STRING contains the text "AAA"

CODE	STRING	Expected Result
111	xxxxAAAxxx	111
111	xxxxxxxxxxx	111
111	xxxxxxxxxxx	111
222	xxxxxxxxxxx
222	xxxxxxxxxxx
222	xxxxxxxxxxx
333	xxxxxxxxxxxx	333
333	xxxxAAAxxx	333

I know it's quite confuse but your help would be very appreciated.  

Thank you very much,
Simao

[simaotc]

Thak you very much! It's Perfect

[DataInsights · Accepted solution]

@simaotc,

Try this calculated column:

Code with AAA = 
VAR vCode = Table1[CODE]
VAR vTable =
    FILTER (
        Table1,
        Table1[CODE] = vCode
            && CONTAINSSTRING ( Table1[STRING], "AAA" )
    )
VAR vResult =
    IF ( ISEMPTY ( vTable ), BLANK (), vCode )
RETURN
    vResult