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 once you used concatenate function, your measure becomes a text, it is no more a number, although there is no solution for this if you are dealing with multiple currencies except using calculation groups. You can always use format function to set the decimal place but it will still be a text.

 

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

    Hi Parry2K,

     

    Thanks for the reply,i tried Format but in that also it doesnt return 2 digit after decimal.

    Can you please give example which you think will work.

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