Forum Discussion

khush19's avatar
khush19
Icon for Resolver I rankResolver I
6 years ago

PowerBI- once Concatenate string with decimal value return value doesnt show 2 digit after decimal

Hi,   I have 2 columns Amount and currency, Based on currency i have to show values in Card.   I have created Measure PaymentReceived = SWITCH(TRUE(), MAX(Report[Currency])="AUD",CONCATENATE(...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

khush19 try this

 

PaymentReceived = 

SWITCH(TRUE(),
MAX(Report[Currency]) IN { "AUD", "USD" }, "$",
MAX(Report[Currency])="MYR","RM"
) & 
FORMAT( [TotalCalculatedAmount], "#0.00" )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

khush19's avatar
khush19
Icon for Resolver I rankResolver I
6 years ago

Thanks Patty2K , it worked 🙂