As always whenever I have some special issues in Power Bi - I came here.
Let me tell you the scenario:
I have a table in Power Bi as below -
Product Name Product Category Price Few other columns
I have created this table from a dataset as "Products". I have a filter for this table and that is "Product Part Number". There are "N" number of products and each products has a separate part number. Now there is a requirement, the products needs to be categorised. The category is based on whether those products promoted or not.
I have a dataset of partnumbers of products those are promoted and the name of the dataset is "Promotion". Now I want to create a custom column in "Products" dataset that will compare the partnumbers from the table with the partnumber column of "Promotion" table and if it matches will return "Yes" or "No".
I think "vlookup" might do it, but couldn't find a good explanation on how to implement that.