Forum Discussion
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...
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.
So you have two single column tables? Where do you want the result to be stored? In one of the tables?
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!
How are you planning to join the tables? Do they have a common column?