Forum Discussion
vijaykaali811
Helper I
Helper Icalculated column using another table scan
Hi I have two table column table1 ======== product description qty category >> calculated field table2 pattern - contains patters eg . product*kids , dress*adult .etc category - K...
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. ✅
anilelmastasi
Super User
Super User
vijaykaali811Helper I
Helper ITable1
product,description ,qty
10, product dress for kids , 10
11, casual dress ware for men xx brand , 11
10, formal dress ware for men xx brand , 10
table2
pattern , category
product*kids , Kids
casual dress*men, Casual men
formal dress*men, formal men