Forum Discussion
Solved
Lookup for a string in a different Table
Hi there, Needing a help with lookup value. I have table 1 and Table 2 as shown below. I need a new calculated column in Table 1 called [New Category] I'd need Power BI to search the string 'Key...
JSIQUEI-YYC-ENB Try this:
New Category = VAR __Table = ADDCOLUMNS( 'Table 2', "__Found", IF( CONTAINSSTRING( [WBS Description], [Key Word]), [Category], BLANK() ) ) VAR __Result = MAXX( FILTER( __Table, [__Found] <> BLANK() ), [__Found] ) RETURN __Result
Thaks for helping Greg.! by the way, I have a copy of your book on my shelf..that's a great source. cheers.