Results 1 to 2 of 2

Thread: Finding a match within one table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Finding a match within one table

    Hello everybody,

    I am struggling to translate the following formula into PowerPivot DAX

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

    What Im 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!

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding a match within one table

    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
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •