(Power Query) How can I combine two columns into one?

[Bear]

How I can combine [rent] & [%Growth] columns into [Final] including the format?

Rent %Growth => Final
2000 0.05 $2,000 (5%)

I tried to use Number.ToText, but it didn't work.

Thank you.

 

[p45cal]

= Table.AddColumn(#"Changed Type", "Final", each Text.Format("$#{0} (#{1})",{Number.ToText([Year 2],"n0"),Number.ToText([Year 2]/[Year 1]-1,"p0")}))

 

[Bear]

= Table.AddColumn(#"Changed Type", "Final", each Text.Format("$#{0} (#{1})",{Number.ToText([Year 2],"n0"),Number.ToText([Year 2]/[Year 1]-1,"p0")}))

Hi p45cal

Thank you so much. May I know if "n0" means removal of decimal, while "p0" means to change of percentage?

 

[p45cal]

In the About section of

Number.ToText - PowerQuery M

Learn more about: Number.ToText

learn.microsoft.com

see below 'The format is a single character code optionally followed by a number precision specifier. '.