Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ask about query

Hi all,   When I have data like Products and Transactions, if in Transform Data, the Products is filtered by some condition, lets say there is Active column then I filtered "Yes" only, then I press...
General Comment
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

From my test, after filtering Product table in Power Query, the original matched value in Transaction table would be changed into blank:

You could use the following formula to creata a new table:

 

Table = FILTER('Transactions', [ID] in VALUES(Products[ID]))

 

 

Or apply the below measure to Filter pane like this:

 

Measure =
IF ( MAX ( 'Transactions'[ID] ) IN VALUES ( 'Products'[ID] ), 1, 0 )

 

Please take a look at the pbix file here.

 

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