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

lbendlin Hi - thank you for responding. To clarify - I used versions of the formulas for both measures and columns. The ones I wrote out were for when I tried to create measures. Please let me know if you need further info.

lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

  • 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!