megatracer
New Member
- Joined
- Jan 21, 2014
- Messages
- 4
Hello everybody,
I am struggling to translate the following formula into PowerPivot DAX
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!
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!