Hi everybody,
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 this approach:
In summary I want the following DAX formula in Power Query:
Regards,
Sherzad
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 this 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"
)
Regards,
Sherzad
Last edited: