Bear Member Oct 8, 2022 #1 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. Attachments PQ_Combine Columns.xlsx 17.8 KB · Views: 5 Last edited: Oct 8, 2022
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 Well-Known Member Oct 8, 2022 #2 Code: = Table.AddColumn(#"Changed Type", "Final", each Text.Format("$#{0} (#{1})",{Number.ToText([Year 2],"n0"),Number.ToText([Year 2]/[Year 1]-1,"p0")}))
Code: = Table.AddColumn(#"Changed Type", "Final", each Text.Format("$#{0} (#{1})",{Number.ToText([Year 2],"n0"),Number.ToText([Year 2]/[Year 1]-1,"p0")}))
Bear Member Oct 8, 2022 #3 p45cal said: Code: = Table.AddColumn(#"Changed Type", "Final", each Text.Format("$#{0} (#{1})",{Number.ToText([Year 2],"n0"),Number.ToText([Year 2]/[Year 1]-1,"p0")})) Click to expand... Hi p45cal Thank you so much. May I know if "n0" means removal of decimal, while "p0" means to change of percentage?
p45cal said: Code: = Table.AddColumn(#"Changed Type", "Final", each Text.Format("$#{0} (#{1})",{Number.ToText([Year 2],"n0"),Number.ToText([Year 2]/[Year 1]-1,"p0")})) Click to expand... Hi p45cal Thank you so much. May I know if "n0" means removal of decimal, while "p0" means to change of percentage?
p45cal Well-Known Member Oct 8, 2022 #4 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. '.
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. '.