Pull data from unrelated table based on 2 columns

[vnqt]

Hi,

I have 2 tables 

Table Product: 

Name	Tag
Name 1	Tag 1
Name 2	Tag 2
Name 3	Tag 3
Name 4	Tag 4
Name 5	Tag 5
Name 6	Tag 6
Name 7	Tag 7
Name 8	Tag 8
Name 9	Tag 9
Name 10	Tag 10

Table Support 

Name	Tag	SLA
Name 1	Tag 1	5/7
Name 22	Tag 2	5/7
Name 33	Tag 3	7/7I
Name 44	Tag 4	7/7I
Name 5	Tag 5	5/7
Name 6	Tag 6	5/7
Name 7	Tag 7	7/7I
Name 8	Tag 8	7/7I
Name 9	Tag 9	7/7R
Name 10	Tag 10	7/7R

I would like to pull the column Support[SLA] to table product with condition: Product[Name] = Support[Name], if  Product[Name] <> Support[Name] then Product[Tag] = Support[Tag]

Could you please help?

Many thanks in advance.

Tg 

[ThxAlot · Accepted solution]

[ThxAlot · Accepted solution]

[Daniel29195]

@vnqt hello ,

try this code and tell me it works  for you . 

new_table =

VAR datasource1 =

    SELECTCOLUMNS(

        'product',

        "product_name", product[Name],

        "product_tag", product[tag]

    )

VAR datasource2 =

    SELECTCOLUMNS (

        'support',

        "support_name", 'support'[Name],

        "support_tag", 'support'[tag],

        "sla", 'support'[SLA]

    )

VAR crossing_tables =  

    CROSSJOIN( datasource1 , datasource2 )

VAR result =

    FILTER (

        crossing_tables ,

        [product_name] = [support_name] || [product_tag] = [support_tag]

    )

RETURN result

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

[vnqt]

Thank you @Daniel29195 

Your solution works but I would like to add the column SLA to the table Product (DAX or PowerQuery) . Do you have any suggestion ? Thank you.

[Daniel29195]

you can use dax : 

create a calculated column in product table as follow : 

maxx(

filter(

support_table, 

support_table[name] = product_table[name] || support_table[tag] = product_table[tag]

)

)

can you try this caclulated column, and tell me if it works .

best regards, 

[vnqt]

hi, 

I got this error "The syntax for "VDI" is incorrect."

Kind regards,

Tg

[Daniel29195]

@vnqt  can you please share w screenshot of the dax you wrote + the error you are having. 

[vnqt]

@Daniel29195 

Too few arguments were passed to the MAXX function. The minimum number of function arguments is 2.

[Daniel29195 · Accepted solution]

@vnqt 

sorry . my mistake . 

let me correct the code : 

maxx(

filter(

support_table, 

support_table[name] = product_table[name] || support_table[tag] = product_table[tag]

) ,

support_table[sla]

)

you need to just add the support_table[sla] 

you can also use @ThxAlot  dax . it works also .