Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |