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,
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.
Regards
Utsav
Solved! Go to Solution.
Hi @utsavlexmark ,
Yes,"lookupvalue" function would help:
Assumed that your 2 tables as as below:
Create a calculated columns similarly as below:
Is promoted =
var _lookup=LOOKUPVALUE('Product Part Number'[Product],'Promotion'[part number],'Product Part Number'[part number],blank())
Return
IF(_lookup<>BLANK(),"Yes","No")
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @utsavlexmark ,
Yes,"lookupvalue" function would help:
Assumed that your 2 tables as as below:
Create a calculated columns similarly as below:
Is promoted =
var _lookup=LOOKUPVALUE('Product Part Number'[Product],'Promotion'[part number],'Product Part Number'[part number],blank())
Return
IF(_lookup<>BLANK(),"Yes","No")
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@utsavlexmark , Create a new column like
Var _cnt = countx(filter(Promotion, Promotion[part number] = partnumbers[partnumbers]),Promotion[partnumbers])+0
return
if(_cnt >0, "Yes", ""No)
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |