Forum Discussion

Bassehave's avatar
Bassehave
Icon for Helper I rankHelper I
4 years ago

Looking for specific text in cell based on another column

I'm trying to do a Find/Mid/Match in Power Query, but I'm not sure how to do it.   Basically, I have a long list of article numbers and article names - inside these articles names it's stated which...
find
Find multiple values
lookup
Match
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Bassehave ,

 

A new column in Table 2 , Items. In DAX

 

new column =

var _max = maxx(filter(X_Colours, search(X_Colours[Color], Item[Name],,0) >0) , X_Colours[Color])

return

if(isblank(_max), "Unknown", _max)

Bassehave's avatar
Bassehave
Icon for Helper I rankHelper I
4 years ago

Hi Amitchandak,

Thanks a lot for the solution and I'm sure its what I need, but I can't seem find where to use this formula. 

When going to "Add Column" and "Custom Column" it doesn't work when I write this formula.

Is it possible to convert it to this window?

I'm trying to do this in Excel Power Query, so I'm not sure if I miss some functionality compared to Power BI query.

 

Thanks in advance!