search a value from other column in a given column for the same row in DAX

[suhasarchak]

Hi,

I am tryinng to find if a value in one column is contained in same row of another column but unsuccessful so far. I have tried SEARCH, FIND functions but not working as expected.

Following is the example:

Column A	Column B	Result
ewkrjewkrje'rj	krj	TRUE
e2q34123	2q	TRUE
kr1eweqwrqw	kr12	FALSE

I want achieve the Result using DAX calculation.

Can someone suggest. Thanks in advance.

Suhas

[Zubair_Muhammad · Accepted solution]

@suhasarchak

SEARCH function works with your sample data

What is your formula?

Result =
SEARCH ( TableName[Column B], TableName[Column A],, 0 ) > 0

[Zubair_Muhammad]

@suhasarchak