Forum Discussion
Solved
Lookupvalue between tables with partial text
Hello all, I need a help with the situation below. I have two table: Table1: Part number Description Status 1252 Bearing Critical 993 Filter Non critical Table2: ...
fhfon , Try a new column in Table2 like
Maxx(filter(Table1, search(Table1[Description], Table2[Description],,0) >0 ), Table1[Status])
Thank you!
This worked as I wanted.
smpa01
Community Champion
Community Championfhfon you can write a measure like this
Measure =
MAXX (
FILTER (
CROSSJOIN (
VALUES ( 'Table 2'[Description] ),
SELECTCOLUMNS (
SUMMARIZE ( 'Table 1', 'Table 1'[Description], 'Table 1'[Status] ),
"_description", [Description],
"status", [Status]
)
),
CONTAINSSTRING ( [Description], [_description] )
),
[status]
)
Thanks! But I could not make this work.