DAX ; Contians, Contains string

[dicken]

Hi,
I've been tryiing out contians ; so ;

ContainM = CONTAINS( Table1, Table1[Customer], "Tom" )


Which return a true /false as expected , but I cannot get CONTAINSSTRING to work at all?
if I enter ;

  ]ContainA = CONTAINSSTRING(

The options to enter a table column as the first argument is not in intelesence


So I tried using values ;

ContainA = CONTAINSSTRING( VALUES( Table1[Customer]), "T")

Which allows me to find the correct column in but otherwise does not work. What am I doing wrong?


Richard.

 

[RoryA]

CONTAINSSTRING tells you if one text value contains another, nothing more.

 

[dicken]

CONTAINSSTRING tells you if one text value contains another, nothing more.

Yes, it was more to do with why I couldn't get it to work, which it now is,
When I was trying this;
]

Table = 
    ROW(
        "Case 1", "AAA", 
        "Case 2", 1234,
        "Case 3", 1& "A", 
        "Case 4", 2& "B" 
    )

Then ;

ADDColum = CONTAINSSTRING( 'Table'[Case 4], "B")

The only way I could get intelisence to give me the Table [column ] option was to use VALUES, and I thought I might be misusing step,
which I may have been but seems to work now. CONTAINS worked fine.

RD