Forum Discussion

Greg_MSFL's avatar
Greg_MSFL
New Member
4 years ago
Solved

Value contained in another column ?

Hi everyone, I search on internet but until now couldn't find a way to answer my problem : I have two tables (and many others, but for this problem, only these two are necessary 🙂 ) :   The firs...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Greg_MSFL , based on what I got

     

    New column in Table 2  =

     

    var _cnt = countx(filter(Table1, table1[ID_CONT] = table2[ID_CONT] && table1[FABRICANT] = table2[FABRICANT] ) , table1[ID_CONT] )

    return

    if(isblank(_cnt), "OK", "KO")

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Greg_MSFL , based on what I got

 

New column in Table 2  =

 

var _cnt = countx(filter(Table1, table1[ID_CONT] = table2[ID_CONT] && table1[FABRICANT] = table2[FABRICANT] ) , table1[ID_CONT] )

return

if(isblank(_cnt), "OK", "KO")

  • Greg_MSFL's avatar
    Greg_MSFL
    New Member
    4 years ago

    Hi amitchandak,

    Awesome, it works perfectly !

    I just changed it a little, because I want to know if the value of Table1 is contained in Table2. So it's now :

    Column2 =
    var _cnt = countx(filter(Table1,Table1[ID_CONT]=Table2[ID_CONT] && CONTAINSSTRING(Table2[FABRICANT],Table1[FABRICANT])),Table1[ID_CONT])
    return
    if(isblank(_cnt),"OK","NOK")
     
    Thanks a lot !
    Have a great day,
    Greg