Use DAX to create a column in which you match data from another table based on part of a word.
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.