FILTER on a part of text in a cell

RickPowerBI — Tue, 19 May 2020 13:34:23 GMT

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:

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!

Re: FILTER on a part of text in a cell

camargos88 — Tue, 19 May 2020 13:41:14 GMT

Try this code to create a new column:

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