Forum Discussion

bballjoe12's avatar
bballjoe12
Frequent Visitor
4 years ago
Solved

How do I create a new table based off another column's rows?

I have a table (the table name is "Tickets") that has 53,000 ticket #s.  On this table, the ticket #s are all unique.  I have another table (the table name is "Ticket History") that includes ticket #...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi bballjoe12 ,

     

    You mean remove all rows from Tickets History table where thicket numbers have not appeared in Ticket Number table?

    This dax code:

    Combined Tables = FILTER('Ticket History',[Ticket Numbers] in VALUES(Tickets[Ticket Numbers]))

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

  • bballjoe12's avatar
    bballjoe12
    Frequent Visitor
    4 years ago

    I tried the innerjoin route and got this error message:

    'No common join columns detected. The join function 'NATURALLEFTOUTERJOIN' requires at-least one common join column.'