Match in PowerPivot

[megatracer]

Hello everybody,

I am struggling to translate the following formula into PowerPivot DAX


=IF(ISERROR(MATCH(A2,B:B, 0)), "Not found", "Found")

IŽd like to be able to find out for each cell in column A, if it exists on column B.


Hopefully youŽd have an idea..

[megatracer]

itŽs either a very stupid question or a very difficult one.

anyone?? help?