Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |