Forum Discussion
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...
Fowmy
Super User
Super UserAnonymous
If you are filtering the Product table with Active ="Yes" then you need to do the same on the transaction table as well in Power Query, if not, once the relationship is created, you see blank values for missing products.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Hi Fowmy
But in my Transaction table there is only Product Id, the Active is in Product table, how to put a relationship to filtered some field in other table in Power Query ?
Thanks,