question

RJ-9871 avatar image
0 Votes"
RJ-9871 asked RJ-9871 edited

Searching text in a column for text in another column in a different table

Hii,


I have two tables,

Table A:

109771-image.png

Table B

109619-image.png


I am working on a filter, where I select a keyword from Table B column. Task is to search the keyword in Table A Keywords column, and return the columns that match the keywords.

For instance: if I select 'Agile' in filters dropdown. search for Agile in Table A and return all the matches.
If I select two items from the filter, It should return matched results accordingly.

This can be accomplished using "Text Search Visual", external plugins/importing. But our organization doesn't encourage it.

Please do help me with DAX expressions to solve it.


Thank you in advance





power-query-not-supported
image.png (38.1 KiB)
image.png (4.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers