Forum Discussion

suji's avatar
suji
Icon for Advocate I rankAdvocate I
9 years ago
Solved

How to display Intersect and except data of two tables

Hi ,   Need help from you on below . I have two table's A and B. There is a common column "id" in A and B. Below is the sample data for ex, A id   Name  age -------------------- 1    aaa   ...
Need Help
  • suji's avatar
    suji
    9 years ago

    Hi Feldmann & Marcel,

     

    Thanks for your quick response.

    today i tried using Append queries option. I appended Table A and Table B and created a new table. After that i created a new custom column to know the record from which table.  It is working exactly what i want.

     

     

    Thanks & Regards,

    Suresh Peddirsi.

     

thiyageshwarans's avatar
thiyageshwarans
Frequent Visitor
8 years ago

Thanks for your reply. it's working...

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello, could you please share how did you use AND in the slicer. I could not get clear from the dax example.

     

    Thanks.

    • ImkeF's avatar
      ImkeF
      Icon for Community Champion rankCommunity Champion
      8 years ago

      This is how the formula is evaluated: