Forum Discussion

PBInewbie00's avatar
PBInewbie00
New Member
1 year ago
Solved

SWITCH using conditions from two tables

Hello,   Searched all over the forum, but I haven't been able to find a good workaround for my problem. I'm trying to create a new column to rename products based on columns from two different tabl...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi PBInewbie00 ,

    I ceate a table as you mentioned.

    Then I think you can create a new calculated column.

    Column = 
SWITCH(
    TRUE(),
    'Table'[PRODUCT] = "Cash" && 'Table'[CODE] = "ASST", "CASH",
    'Table'[PRODUCT] = "Assets" && 'Table'[CODE] = "ASST", "ASST",
    'Table'[PRODUCT] = "Commission" && 'Table'[CODE] = "COMM", "COMM",
    'Table'[PRODUCT] = "Derivatives" && 'Table'[CODE] = "DERIV", "DERIV",
    'Table'[PRODUCT] = "Cash" && 'Table'[CODE] = "DERIV", "CASH",
    'Table'[PRODUCT] = "Cash" && 'Table'[CODE] = "LOAN", "CASH",
    'Table'[PRODUCT] = "Loans" && 'Table'[CODE] = "LOAN", "LOAN",
    BLANK()
)

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PBInewbie00's avatar
PBInewbie00
New Member
1 year ago

Hi lbendlin - I provided the table at the end of the my original post with the sample data, expected results, and current results.

 

Reposting below for convenience. Please let me know if this is not sufficient.

 

CODEPRODUCTEXPECTEDCURRENT
ASSTCashCASHASST
ASSTAssetsASSTASST
COMMCommissionCOMMCOMM
DERIVDerivativesDERIVDERIV
DERIVCashCASHDERIV
LOANCashCASHLOAN
LOANLoansLOANLOAN
lbendlin's avatar
lbendlin
Super User
1 year ago

So you have two single column tables?  Where do you want the result to be stored? In one of the tables?

  • PBInewbie00's avatar
    PBInewbie00
    New Member
    1 year ago

    lbendlin The two tables have other columns, but I'm trying to pull from those specific columns. I'm ok with storing the results in one of the tables (I wasn't sure if storing it in a specific table was affecting the actual result). Thanks again for your help on this!

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      How are you planning to join the tables? Do they have a common column?