absherzad
New member
- Joined
- Jul 27, 2017
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi All,
How it is possible in Power Query to partially search if a value in one dataset exists in the second one. I want to replace the following below approach:
In summary, I want the following DAX formula in Power Query:
How it is possible in Power Query to partially search if a value in one dataset exists in the second one. I want to replace the following below approach:
Code:
if Text.Contains([Column in 2nd Dataset], "Keyword 1") or
Text.Contains([Column in 2nd Dataset], "Keyword 2") or
Text.Contains([Column in 2nd Dataset], "Keyword 3") or
Text.Contains([Column in 2nd Dataset], "Keyword 4")
then
"Matched"
else
"Not Matched")
In summary, I want the following DAX formula in Power Query:
Code:
=IF (
SUMX ( MatchList, SEARCH( Dataset1[Keywords], Dataset2[Column in 2nd Dataset], 1, 0 ) ) > 0,
"Matched",
"Not Matched"
)