cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
henriwestra
Frequent Visitor

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

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. 

 

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?

3 REPLIES 3
henriwestra
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.

henriwestra_0-1607596406631.png

 

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.

AntrikshSharma
Resident Rockstar
Resident Rockstar

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

1.png

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors