DAX Query with 'LIKE%'

[thampton]

Hello. I have a SSAS tabular model that i need to query using dax. I need to be able to write a query having a where (filter in dax) clause using the 'LIKE '%Test%' ' in SQL.

How can i translate this to dax? :

Select * From Table1 Where ColumnName LIKE '%Test%'

[BewhY]

Check it out.

https://www.sqlbi.com/articles/from-sql-to-dax-string-comparison/

[Greg_Deckler]

Take a look at the SEARCH and FIND functions.