Create a column "if the cell contains"

[nataliesmiy1357]

Hello!  I am looking to create a column in my table to create a personalized filter.

I am wanting to create a column that is basically "if this cell contains x, y, and z, print Unit"

This is what I wrote... but it isn't working right now.  Just not sure how to create this formula.

Type of Plant =

IF(CONTAINS(Merge1, Merge1[Plant and Line], "TMMAL", Merge1[Plant and Line], "TMMK PWT", Merge1[Plant and Line], "TMMWV"), "Unit",

IF(CONTAINS(Merge1, Merge1[Plant and Line], "TMMBC", Merge1[Plant and Line], "TMMI", Merge1[Plant and Line], "TMMK", Merge1[Plant and Line], "TMMC", Merge1[Plant and Line], "TMMGT", Merge1[Plant and Line], "TMMTX"), "Vehicle",

"NEED TO INCLUDE"))

Thanks in advance!

[nataliesmiy1357 · Accepted solution]

I tried that... but it didn't work.  My data that I'm pulling from looks like this:

January TMMWV TNGA

So I need to pull if that line has TMMWV, print Unit.

Thanks again!

[DataInsights]

@nataliesmiy1357,

Try this calculated column:

Type of Plant = 
SWITCH (
    TRUE,
    Merge1[Plant and Line] IN { "TMMAL", "TMMK PWT", "TMMWV" }, "Unit",
    Merge1[Plant and Line] IN { "TMMBC", "TMMI", "TMMK", "TMMC", "TMMGT", "TMMTX" }, "Vehicle",
    "NEED TO INCLUDE"
)

[nataliesmiy1357 · Accepted solution]

I tried that... but it didn't work.  My data that I'm pulling from looks like this:

January TMMWV TNGA

So I need to pull if that line has TMMWV, print Unit.

Thanks again!

[DataInsights · Accepted solution]

@nataliesmiy1357,

Try this:

Type of Plant =
SWITCH (
    TRUE,
    CONTAINSSTRING ( Merge1[Plant and Line], "TMMAL" )
        || CONTAINSSTRING ( Merge1[Plant and Line], "TMMK PWT" )
        || CONTAINSSTRING ( Merge1[Plant and Line], "TMMWV" ), "Unit",
    CONTAINSSTRING ( Merge1[Plant and Line], "TMMBC" )
        || CONTAINSSTRING ( Merge1[Plant and Line], "TMMI" )
        || CONTAINSSTRING ( Merge1[Plant and Line], "TMMK" )
        || CONTAINSSTRING ( Merge1[Plant and Line], "TMMC" )
        || CONTAINSSTRING ( Merge1[Plant and Line], "TMMGT" )
        || CONTAINSSTRING ( Merge1[Plant and Line], "TMMTX" ), "Vehicle",
    "NEED TO INCLUDE"
)