Merging two different columns based on selection

[sreddy47652]

Hi Team, I have two seprate columns like Fee payment(No Payment required-Single event, One of Payment, Not applicable, other), Amount fields. When i select in dropdown as other i want to concatanate other+Amount(It should show like "Other 50$") same way when i select Fee payment as "one of payment" it should show only "one of payment"(No concatation required). How to concate two columns based on drop down selection in power bi, i need only concatanate when user select as other.

[v-henryk-mstf · Accepted solution]

Hi @sreddy47652 ,

Whether the advice given by @johncolley  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[johncolley]

Hi @sreddy47652 , You can accomplish this using the SWITCH function in a new column, please see an example below:

Combined = 
var paymenttype = 'Column condition merge'[Fee Payment]
var amount = 'Column condition merge'[Amount]
var result =  SWITCH(
    TRUE(),
    paymenttype = "Other", COMBINEVALUES(" - ", paymenttype, amount),
    paymenttype)
    Return
    result

If this answer solves your problem please mark it as a solution!