topic Searching for text containing key words in DAX Commands and Tips

Searching for text containing key words

drwinny — Fri, 11 Dec 2020 10:40:04 GMT

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,

Re: Searching for text containing key words

nandukrishnavs — Fri, 11 Dec 2020 13:36:40 GMT

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

Re: Searching for text containing key words

drwinny — Fri, 11 Dec 2020 13:43:22 GMT

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.