Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Description | Status |
Bearing 3cm stainless steel | |
Exhaust HEPA Filter |
What I need is kind a "lookupvalue" with partial text that will bring the status from the table1 to table2, but the issue is that description in table2 has more information.
Please, HELP me! 🙂
Att.
Fernando Nobre
Solved! Go to Solution.
@fhfon , Try a new column in Table2 like
Maxx(filter(Table1, search(Table1[Description], Table2[Description],,0) >0 ), Table1[Status])
@fhfon 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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |