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.

     

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
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.