Use DAX to create a column in which you match data from another table based on part of a word.

[henriwestra]

Hello,

I have two tables. Table 1 contains descriptions (see example). table 2 lists keywords. I would like to use DAX in table 1 to create an extra column in which it is indicated whether some of the keywords in table 2 appear in a description of table 1. 

I have to do this in DAX because I want to get the data in direct query mode. I know how to merge with contains in the query edirot, but then direct query is not an option anymore.

Who has the golden tip?

[henriwestra]

Hey @AntrikshSharma ,

thanks for your help. it look's like the solution.

But the 'COUTROWS' function is not allowed in a calculated collumn in direct query models.

Is there a way to do this in direct qeury mode?

[AntrikshSharma]

@henriwestra  Completely forgot about the direct query part. It looks like you will have to do this either through a measure and show it in the report or do it in Power Query.

[AntrikshSharma]

@henriwestra  Created a dummy file for you, try this and let me know the feedback. The file is attached below my signature.