Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello.
I have a 'Product' table, it has a 'Product Code' column and multiple attribute columns. It is an enormous data-set, as it has all the product a company as produced in its history.
In addition, I have an 'Inventory' table and a 'Sales' table. These also have a 'Product Code' column.
In order to reduce my query size, I want to query only the 'Product Codes' in the 'Product' table that appear in both the 'Inventory' and 'Sales' tables.
How do I do this?
I've started with something like this, but it's not working, I may be way off:
= Table.SelectRows(#"Product", each List.Contains(Table.Column(#"Inventory", "Product Code"), [Product Code]) and List.Contains(Table.Column(#"Sales", "Product Code"), [Product Code]))
Alternatively, maybe I can do a sort of lookup column where if Product Code appears in 'Inventory' and 'Sales', mark an "X", and then query only rows that contain an "X"? But I haven't figured out the code for that route.
Thank you!
Thanks, @HotChilli
I'm very new to writing this kind of code. Do you have an example of how I would need to type that in?
Maybe use List.Intersect to create a list of product codes in Inventory and Sales tables.
Then use Table.SelectRows on the Product table with List.Contains passing the list you created and the Product code.
--
I advise reducing your tables to a few rows to use as a test when writing the code
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.