Filter a table using a column in another table

Question

Hello Community ,&nbsp;&nbsp;&nbsp; I have Two Table&nbsp;Table 1 :&nbsp; with a column where there is a comment entered by a user :&nbsp;&nbsp;RowDescription1&nbsp;This is&nbsp; a invoice&nbsp; IV12342IV4356-for client&nbsp;3CustomerIV5678Incoiced&nbsp;Table 2&nbsp; :&nbsp;&nbsp;Invoice ID&nbsp;AmountIV12341000IV43561500&nbsp;&nbsp;&nbsp;I want to filter table1 with only the Invoice ID in table 2&nbsp; ( Description Contains InvoiceID) and add a column with Invoice ID in table if possible&nbsp;&nbsp;Does any one have a idea or a suggestion ?&nbsp;&nbsp;Best Regards&nbsp;Thank you for your help&nbsp;

jihwan_kim · Accepted Answer

Hi,
Please check the below picture and the attached pbix file.
It is for creating a new table.
&nbsp;

&nbsp;
&nbsp;
New table =
SUMMARIZE (
    GENERATE (
        'Table 2',
        FILTER (
            'Table 1',
            CONTAINSSTRING ( 'Table 1'[Description], 'Table 2'[Invoice ID] )
        )
    ),
    'Table 1'[Row],
    'Table 1'[Description],
    'Table 2'[Invoice ID]
)

Forum Discussion

Filter a table using a column in another table

2 Replies

Related content

find max value based on another filtered column

Filter a column based on another column

Sort by another column

Slicer for filtering several columns

Find Most Recent Date Relative to another Date Column in Power Query

Row	Description
1	This is a invoice IV1234
2	IV4356-for client
3	CustomerIV5678Incoiced

Invoice ID	Amount
IV1234	1000
IV4356	1500