Convert Fixed Decimal To Text

[SteveDesmedt]

Hi all, 

I have a column of type "Fixed Decimal Number".  When i convert this to text, the decimal places dissapear.

What i want to achieve is to merge cells withou removing the decimals  :

125,23 USD

2.558,58 EUR

558,00 EUR

When i merge the columns, decimal places dissapear (if ,0 or ,00 or ,5 or ...)

I want to keep the two decimal places always.

Anyone can help me ?

Regards

steve

[slorin]

Hi,

Add column

Number.ToText([AMOUNT],"F") &" "& [CURRENCY]

https://gorilla.bi/power-query/custom-format-strings/

or 

= Table.CombineColumns(
      Table.TransformColumns(
          PrevStep,
          {{"AMOUNT", each Number.ToText(_,"F")}}),
      {"AMOUNT", "CURRENCY"},
      Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),
      "Merged"
)

Stéphane