Separate by commas in measure

[Anonymous]

Hi all, I have this measure, but I wanna separate by commas the thousends in the amounts, how could I do that here in dax w/measures?

Total Demurrage =

VAR txt1 = "Total Demurrage = $"

VAR sum1 =  SUM(Elev[Demurrage(credits 1=$150)])

VAR txt2 = "   Real Amount = $"

VAR sum2 =  sum1 * 150

RETURN

txt1 & sum1 & txt2 & sum2

Regards

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try:

Total Demurrage =
VAR txt1 = "Total Demurrage = $"
VAR sum1 =
    FORMAT ( SUM ( Elev[Demurrage(credits 1=$150)] ), "0,000" )
VAR txt2 = "   Real Amount = $"
VAR sum2 =
    FORMAT ( sum1 * 150, "0,000" )
RETURN
    txt1 & sum1 & txt2 & sum2

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

Thank you so much, you solved it so simple, I did not know that possibility with "FORMAT"

Regards

[vicky_]

Use the FORMAT function instead: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

[Anonymous]

Thank you so much, I do not why I couldn't use it in my measure

Regards