Create custom column from other tables

[rajkiran_tadaka]

Hi All,

I have a requirement to create custom column rom different tables.

Below is the scenario.

if ('Region_Table'[RGN_CODE]='APAC' and 'Products_Table'[Product Line] = 'RD79') then ('ABC')
else if ('Region_Table'[RGN_CODE]='EMEA' and 'Products'[Product Line] in ('RD79','RD80')) then ('EFG')
else ('XYZ')

Thanks in Advace.

[v-cherch-msft]

Hi @rajkiran_tadaka 

You may create a calculated column in Region_Table as below.Please make sure the two tables are linked as One to One or One(Products_Table) to More(Region_Table) in relationship view.

Column =
IF (
    Region_Table[RGN_CODE] = "APAC"
        && RELATED ( Products_Table[Product Line] ) = "RD79",
    "ABC",
    IF (
        Region_Table[RGN_CODE] = "EMEA"
            && RELATED ( Products_Table[Product Line] ) IN { "RD79", "RD80" },
        "EFG"
    )
)

Regards,

Cherie

[rajkiran_tadaka]

Hi @v-cherch-msft ,

Thank you for your reply,

Actually these two dimension tables don't have direct relationship. These two dimensions are joined to FACT_SALES table.

Can you plesae advice.

Thanks,

RajKiran

[v-cherch-msft]

Hi @rajkiran_tadaka 

You may use LOOKUPVALUE function.If you need further help,please share some data sample. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie