cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Wildcard match values based on lookup from separate table and show in Visual

Hi, looked around for few days and have not found answer, hoping someone can help? 

 

I have a table let's call it "MAIN", it has all the data like part number, description, revenue, gp and more. 

 

In Description are long text strings and in the start or middle somewhere are product names, let's say Arista or Meraki etc. 

I would really like to have a table visual that shows the values from another table I create called "MODELS" but lookup each of those values in the description column in the other table, and show revenue and gp etc. 

 

The MODELS table looks like this: 

 

Models.GIF

The visual I have currently that feeds from MAIN table looks like this: 

 

DESCRIPTION.GIF

I would love to show a visual that has matches the DESCRIPTION above *Arista* WHERE Group = Network then show Revenue and GP totals for all matches of *Arista*, and do that for anything in that Table all the way down, if I add something to the table then it also shows the revenue / gp. 

 

Is this possible? Hoping I am describing this correctly? 

 

Not sure if this is a Measure or need to do something on Query Editor side?

 

Thank you!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Continued Contributor
Continued Contributor

Hi @sscanlon 

 

I've found this thread which I think is close to what you are looking for.

 

https://community.powerbi.com/t5/Desktop/Wildcard-matching-amp-returning-a-value/td-p/470276

 

 

View solution in original post

2 REPLIES 2
Highlighted
Continued Contributor
Continued Contributor

Hi @sscanlon 

 

I've found this thread which I think is close to what you are looking for.

 

https://community.powerbi.com/t5/Desktop/Wildcard-matching-amp-returning-a-value/td-p/470276

 

 

View solution in original post

Highlighted

Thank you! that was perfect, copied the logic and was able to do what I wanted, thank you!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors