Forum Discussion

Kamill11's avatar
Kamill11
Icon for Helper I rankHelper I
4 years ago

compare columns with text values in different queries

Hi everyone, I need to do measure for: if the value in column 1 is contained in column 2 then it displays "YES", if none it displays "NO", Columns are in different queries, and they both are in...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Kamill11 , A new column

var _col = [Column1]

return

if(search(_col, [column2],,0) >0 , "Yes", "No")

  • Kamill11's avatar
    Kamill11
    Icon for Helper I rankHelper I
    4 years ago

    Should work, but the column1 and column2 are in different queries, and report is in DirectQuery mode.  Is that problem or I do something wrong?