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

[efhache]

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 column  "userID".

I would like to add a new column when the result is true when (querry1[action_1_byuserID] = querry2[UserId]) AND (querry1[action_2_byuserID] = querry2[UserId]) AND (querry1[action_3_byuserID] = querry2[UserId]).

Sure I could use three merge querry to solve it, but there is may be a better way, no?

Some one can help me ?

[amitchandak · Accepted solution]

@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]

Thanks a lot for the help

[efhache]

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