none
Format a decimal number to percentage form, e.g. 0.01 to 1% RRS feed

  • Question

  • Hi all,

    As titles, i want to format a decimal number to percentage form, e.g. 0.01 to 1%. I can't find it in PQ.

    Thanks,

    Arthur


    Keep involved!

    Tuesday, December 16, 2014 3:53 AM

Answers

  • PQ doesn't currently have a way to specify number formats (that's usually done in Excel after filling the data to the sheet, or in Power Pivot). But if you want to generate some text that represents a number as a percentage, you can use this formula:

    = Text.From(TheNumberYouWantToFormat * 100) & "%"

    Ehren

    Tuesday, December 23, 2014 6:22 PM
    Owner

All replies

  • PQ doesn't currently have a way to specify number formats (that's usually done in Excel after filling the data to the sheet, or in Power Pivot). But if you want to generate some text that represents a number as a percentage, you can use this formula:

    = Text.From(TheNumberYouWantToFormat * 100) & "%"

    Ehren

    Tuesday, December 23, 2014 6:22 PM
    Owner
  • PQ doesn't currently have a way to specify number formats (that's usually done in Excel after filling the data to the sheet, or in Power Pivot). But if you want to generate some text that represents a number as a percentage, you can use this formula:

    = Text.From(TheNumberYouWantToFormat * 100) & "%"

    Ehren

    Any plans to add this functionality in the future?

    Keep involved!

    Sunday, January 4, 2015 5:33 AM
  • I would definitely be interested in this functionality.
    Friday, September 27, 2019 9:08 PM