Forum Discussion
Helper Icalculated column using another table scan
But user says that only category column.
You an try this vijaykaali811 ,
Category =
VAR descText = table1[description]
VAR matchedCategory =
MAXX(
FILTER(
table2,
SEARCH(
SUBSTITUTE(table2[pattern], "*", ""),
descText,
1,
0
) > 0
),
table2[category]
)
RETURN
matchedCategoryIf this solved your issue, please mark it as the accepted solution. ✅
Super UserHi vijaykaali811
Can you please try the below steps?
Use the below DAX
- anilelmastasi
But user says that only category column.
You an try this vijaykaali811 ,
Category =
VAR descText = table1[description]
VAR matchedCategory =
MAXX(
FILTER(
table2,
SEARCH(
SUBSTITUTE(table2[pattern], "*", ""),
descText,
1,
0
) > 0
),
table2[category]
)
RETURN
matchedCategoryIf this solved your issue, please mark it as the accepted solution. ✅
vijaykaali811it worked like a charm . thank you a lot . just removed subsitute section as per my requirement