Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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. 


Dax contains.JPG

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?

Frequent Visitor

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.

Community Champion
Community Champion

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



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors