Ceck if cell contains a series of numbers

[Anonymous]

Hi all!!

I have a data table with numbers, of which some of them contain a specific series of numbers.

key

x843xxxxx

x843xxxxx

xxxxxxxxx

x843xxxxx

How do I make a calculated collumn in which I can indicate wether those numbers are contained in each row or not?

I tried

Calculated Collumn =
IF(
    CONTAINS('datatable','datatable'[key],843),
    "YES",
    "NO"
)

but that didn't work. I guess CONTAINS does not work on a row to row basis.

Thanks!! 🙂

[ChrisMendoza · Accepted solution]

@Anonymous - Use CONTAINSSTRING( ).

[Anonymous]

okay that was an easy fix, thanks!! 🙂