Text formating question

[Akos9207]

Hi,

I would like to ask for help with the following problem.

I have 3 numeric columns (menny, btknettoar, btkbruttoar), all columns are decimal value with 4 digits after comma and i would like to concatenate together.  

I use the following:

"Mennyiség: " & Number.ToText(Number.Round([menny],2)) & " Nettó ár: " & Number.ToText (Number.Round([btknettoar],2)) & " Bruttó ár: " & Number.ToText (Number.Round([btkbruttoar],2))

The result:

Mennyiség: 12.0000 Nettó ár: 491.0000 Bruttó ár: 623.5700

I would like to get the following (only 2 digits after comma):

Mennyiség: 12.00 Nettó ár: 491.00 Bruttó ár: 623.57

Is it possible to format the values? The original colums cannot be formated to use only 2 digits, i need all 4 digits for other purposes, so that is not an option.

Thank you.

[FreemanZ]

hi @Akos9207 

try to wrap with Number.RoundUp:

https://learn.microsoft.com/en-us/powerquery-m/number-roundup

[Barthel · Accepted solution]

Hey @Akos9207, 

You could use the FIXED function. Rounds a number to the specified number of decimals and returns the result as text. You can specify that the result be returned with or without commas.

https://learn.microsoft.com/en-us/dax/fixed-function-dax

[Akos9207]

Thank you.