Return specific item name

[knassoro99]

Hello,

I have Kitchen inventory table with Item name column & I want to return all the item name "cake".only. How do I solve this?

Thanks

[jballester]

Hi,

you can test

Select(Kitchen inventory[Item code],CONTAINS([item name],"cake"))

[knassoro99]

Thanks for your response. It still did not work maybe the word specific cake1/2, cake1kg, etc

[jballester]

I don't think, contains() works with fragments and is not case sensitive.

Can you give more information about the column type and where you are writing the function?

[knassoro99]

In the above table "kitchen Inventory" I created a virtual col and use it there

[knassoro99]

Virtual col

[firhidayat96]

do you want to filter only "cake" or using field (Dynamics) with specific word? have you tried using filter and contains ( )? 

[knassoro99]

I want to filter any word contain "Cake"