I have 2 tables as below -
ID ProductCat123 Appliances131 Laptops130 Mobiles129 Appliances128 Laptops127 Mobiles126 Appliances125 Laptops124 Mobiles
Category IDMobiles 123Appliances 124Laptops 124Appliances 125Laptops 125Appliances 126Mobiles 126Laptops 127Appliances 128Mobiles 127Laptops 128Appliances 129Mobiles 129Laptops 130Mobiles 130Appliances 131Laptops 131
I want to do the following -
Create a flag column in Table A which will set value to Yes if a particular category in Table A for an ID matches with any one of categories in Table B for that ID.
Lookup won't work here as it will give error - "A table of multiple values...."
I tried this
But somehow I want to filter the result of concatenatex to be just for a particular ID. However, above column will always take all values of category.
Go to Solution.
Try this pattern
FILTER ( TableB, TableA[ID] = TableB[ID] && TableA[ProdCat] = TableB[ProdCat] )
View solution in original post
Find out how to participate in the first Power BI 'Can You Solve These?' challenge.
Get your latest community news and announcements.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Each week, complete activities and be qualified in the drawing for cool Power BI Swag.