FILTER on a part of text in a cell

[RickPowerBI]

Hi,

I want to filter a column that has very similar content. So I am trying to filter on a part of the text that is in a single cell.

This is what the data looks like:

Account	Product
Power sold	Green 1 year
Power sold	Green variable
Power sold	Received green variable
Power sold	Received green 2 year

I need to filter on “Received”. In SQL you would just use LIKE(“x*”) but how does this work in DAX/Power BI?

PS: There is no other colomn with a distinct value

Thanks in advanced!

[camargos88 · Accepted solution]

Hi @RickPowerBI ,

Try this code to create a new column:

Filter = IF(SEARCH("Received"; 'Table'[Product];1;-1) > 0; 1;0)