Compare Two Columns From Different Tables
Results 1 to 3 of 3

Thread: Compare Two Columns From Different Tables
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Posts
    166
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Compare Two Columns From Different Tables

    Hello,

    I would like to compare Table1 Column1 with Table2 Column2. If Column1 value =Column2 value it should be printed "Match" if not "No Match". Both columns are formatted as text. I guess, this should be Custom Column and DAX formula.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,569
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Compare Two Columns From Different Tables

    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,569
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Compare Two Columns From Different Tables

    or you can try this as a model to be expanded

    Code:
    // Table1
    let
        Source1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        Source2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
        Compare = Table.AddColumn(Source2, "Compare", each List.Contains(Source1[type],[type])),
        ROC = Table.SelectColumns(Compare,{"Compare"})
    in
        ROC
    but result is TRUE / FALSE
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

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
  •