Searching for text containing key words

[drwinny]

Hi All,

I am working in Power BI service using DirectQuery mode.

I want to search for keywords in a free text feld and then say true of false if the keyword can be found or not. 

Ideally this would be a measure, I used a conditional column with this code:

= Table.AddColumn(#"Added Conditional Column", "SearchText", each if Text.Contains([eps_description], "FW") then "Firmware" else if Text.Contains([eps_description], "Firmware") then "Firmware" else if Text.Contains([eps_description], "Panel") then "Panel" else if Text.Contains([eps_description], "Settings") then "Settings" else false)

But I get an error "This step results in a query that is not supported in DirectQuey mode Switch all tables to import mode"

Can the above be done as a measure?

Many Thanks for your help,

[nandukrishnavs · Accepted solution]

@drwinny 

Try to implement the column logic in the source table. Or, try to create a calculated column using DAX.

example:

Status = 
var _x=database_file[root_path]
var _result= CONTAINSSTRING(_x,"MSSQL")
return _result

[drwinny]

Sorry i am new to DAX and don't really understand the example, I will ask for it to be added to the database view that I am using.

Thanks for trying to help me.