Forum Discussion

efhache's avatar
efhache
Frequent Visitor
4 years ago
Solved

Add columns with the true/false value based on a comparaison from other one source

Hi, I've two sources "querry1" and "querry2".  Querry1  contains a lot of columns but three of them are  "action_1_byuserID", "action_2_byuserID"  and "action_3_byuserID". Querry 2 contain a col...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    efhache ,


    DAX
    new column in query 1 =
    var _cnt = countx(Filter(querry2, querry1[action_1_byuserID] = querry2[UserId] && querry1[action_2_byuserID] = querry2[UserId] && querry1[action_3_byuserID] = querry2[UserId]), querry2[UserId])
    return
    if(isblank(_cnt), false(), True())

     

     

    DAX
    new column in query 2 =
    var _cnt = countx(Filter(querry1, querry1[action_1_byuserID] = querry2[UserId] && querry1[action_2_byuserID] = querry2[UserId] && querry1[action_3_byuserID] = querry2[UserId]), querry1[action_3_byuserID] )
    return
    if(isblank(_cnt), false(), True())

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

efhache ,


DAX
new column in query 1 =
var _cnt = countx(Filter(querry2, querry1[action_1_byuserID] = querry2[UserId] && querry1[action_2_byuserID] = querry2[UserId] && querry1[action_3_byuserID] = querry2[UserId]), querry2[UserId])
return
if(isblank(_cnt), false(), True())

 

 

DAX
new column in query 2 =
var _cnt = countx(Filter(querry1, querry1[action_1_byuserID] = querry2[UserId] && querry1[action_2_byuserID] = querry2[UserId] && querry1[action_3_byuserID] = querry2[UserId]), querry1[action_3_byuserID] )
return
if(isblank(_cnt), false(), True())

efhache's avatar
efhache
Frequent Visitor
4 years ago

Indeed via DAX... it's analysis.  Thanks, it helps, just change AND by OR  and works for me