Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Icon for Helper V rankHelper V
3 years ago
Solved

lookup Value from another table without relationship

Hi All,   I wanted to know if there is any possibility of searching a keyword from 1st table and getting the lookup value from the second table. 1st Table Name Definition of climate   ...
Need Help
Show and Tell
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    column

    column = COALESCE(
CALCULATE(MAX('Table_2'[Tag]),
    FILTER ( 'Table_2', CONTAINSSTRING ( 'Table_1'[Name], 'Table_2'[Keyword]) )),"Other")

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, RanjanThammaiah 

 

You can try the following methods.

Column = 
IF (
    SEARCH ( "Climate", [Name],, 0 ) <> 0,
    LOOKUPVALUE ( Table2[Tag], Table2[Keyword], "Climate" ),
    "Other"
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.