Forum Discussion
Convert word with specific text
Hi, ngocnguyen
Try this:
Measure = VAR cname = MAX ( Table1[Customer name] ) RETURN MAXX ( FILTER ( Table2, FIND ( Table2[Snip-to Party Name], cname,, -1 ) > 0 && LEN ( Table2[Snip-to Party Name] ) = IF ( LEN ( Table2[Snip-to Party Name] ) = LEN ( cname ), LEN ( Table2[Snip-to Party Name] ), MAXX ( SUMMARIZE ( Table2, [Snip-to Party Name], [Convert], "length", LEN ( Table2[Snip-to Party Name] ) ), [length] ) ) ), [Convert] )Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yep, measure is ok, but your suggested measure not yet solved my problem. Could you please suggest me another measure ?
Sorry, ngocnguyen
Your data NK, XNK may cause conflicts,and I entered the data with inconsistent case.
Try this:
Measure =
var cname = MAX(Table1[Customer name])
return
MINX (
FILTER (
Table2,
FIND (Table2[Snip-to Party Name], cname,,-1) > 0
),
Table2[Convert]
)If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your support. I do as the same your instruction. However, for case "XNK", the convert result is still" Nguyen Kim" While the correct result should be blank T_T
Yes, I changed already but still not get the correct result. Could you pls send me your instance of power bi
Measure =
var cname = max(Table1[Customer name])
return
MinX (
FILTER (
Table2,
FIND (Table2[Ship-to Party Name],cname,,-1) > 0
),
Table2[Convert]
)