topic Re: Join whitout direct relationship in DAX Commands and Tips

Join whitout direct relationship

Anonymous — Wed, 25 Nov 2020 05:20:10 GMT

hi, i need help with this case:

i have two tables linked by link table like this:

now I want to add columns from the "AC_CONTACTOS" table to the "AC_GANADOS" table using email as a key, (similar to SQL's left join) but I haven't been able to, because there is no direct relationship between the two tables.

Does anyone have any idea how to do it?

Re: Join whitout direct relationship

amitchandak — Wed, 25 Nov 2020 06:07:12 GMT

Anonymous , You have to bring it to the table having email and then move in from there to another table. 2 steps.

Refer to this video for the option to copy .: https://youtu.be/czNHt7UXIe8

Re: Join whitout direct relationship

wdx223_Daniel — Wed, 25 Nov 2020 08:34:34 GMT

maybe LOOKUPVALUE can help

Re: Join whitout direct relationship

Anonymous — Wed, 25 Nov 2020 10:45:30 GMT

So, it looks like in fact the connection from the one-side table to the many-side table (AC_Contactos) is 1 to 1? If there is more than 1 row in AC_Contactos for one row in the one-side table, how do you want to handle this?