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")