cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
utsavlexmark
Helper III
Helper III

Need Help in Data Customization

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

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi  @utsavlexmark ,

 

Yes,"lookupvalue" function would help:

Assumed that your 2 tables as as below:

v-kelly-msft_1-1623653441490.pngv-kelly-msft_2-1623653449626.png

 

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:

v-kelly-msft_0-1623653354264.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi  @utsavlexmark ,

 

Yes,"lookupvalue" function would help:

Assumed that your 2 tables as as below:

v-kelly-msft_1-1623653441490.pngv-kelly-msft_2-1623653449626.png

 

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:

v-kelly-msft_0-1623653354264.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

View solution in original post

amitchandak
Super User
Super User

@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)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!