Forum Discussion

khush19's avatar
khush19
Resolver 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("$",[TotalCalculatedAmount]),
MAX(Report[Currency])="USD",CONCATENATE("$",[TotalCalculatedAmount]),
MAX(Report[Currency])="MYR",CONCATENATE("RM",[TotalCalculatedAmount])
)
 
But this doesnt 2 digits after decimal and thosand seperator.
I am setting up the
But it isnot working and i tried Format also but not working
Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super 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
      Resolver 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
        Super 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!

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    khush19 , try like

    PaymentReceived = SWITCH(TRUE(),
    MAX(Report[Currency])="AUD",CONCATENATE("$",round([TotalCalculatedAmount],2)),
    MAX(Report[Currency])="USD",CONCATENATE("$",round([TotalCalculatedAmount],2)),
    MAX(Report[Currency])="MYR",CONCATENATE("RM",round([TotalCalculatedAmount],2))
    )

     

    But my suggestion would be show symbol in a separate column Create a Column with the symbol and rename it the visual with One Character and use that near to value field