Finding a match within one table

[megatracer]

Hello everybody,

I am struggling to translate the following formula into PowerPivot DAX

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

What I´m trying to do - I have a table in Powerpivot; there I want to be able to find out for each cell in column A, if it exists on column B and put result (Found/Not found) in column C.

Your help is really appreciated!

 

[Matt Allington]

Why are you trying to do this? It doesn't sound like good Power Pivot Practice. Have a read of these 2 articles nad then take a step back and consider if you are approaching the problem in the right way. What is the actual problem you are trying to solve (as opposed to doing it this way).

Calculated Columns vs Measures in DAX - Excelerator BI
Shaping vs Modelling in Power BI - Excelerator BI