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?
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?
@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.
@henriwestra Created a dummy file for you, try this and let me know the feedback. The file is attached below my signature.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
104 | |
35 | |
32 | |
29 | |
21 |
User | Count |
---|---|
122 | |
49 | |
41 | |
33 | |
20 |