Forum Discussion

_Martin123's avatar
_Martin123
Frequent Visitor
2 years ago
Solved

Lookup string value from unrelated table in ranked order

Hi Community,   I need your support.   I have two unrelated tables, where Table 1 consists of comments made by sales reps, whereas table 2 consists of lookup texts used to group comments in table...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    CalculatedColumn=MAXX(TOPN(1,FILTER(Table2,FIND(Table2[LookupText],Table1[Comments],1,0)),Table2[textRank],ASC),Table2[Comment group])

  • ThxAlot's avatar
    ThxAlot
    2 years ago
    Comment Group = 
MAXX(
    TOPN(
        1,
        FILTER( Table2, CONTAINSSTRING( Table1[Comments], Table2[Lookup text] ) ),
        Table2[Rank], ASC
    ),
    Table2[Comment group]
)

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

CalculatedColumn=MAXX(TOPN(1,FILTER(Table2,FIND(Table2[LookupText],Table1[Comments],1,0)),Table2[textRank],ASC),Table2[Comment group])