Convert number into %

[Omid_Motamedise]

In excel there is a function like text to convert a value into any format like Text(2,"0%") which results in 2%, how we can convert the number 2 to 2% in power query except using Text.From(2)& "%"?

[AlienSx · Accepted solution]

2 is 200%, not 2% and TEXT(2, "0%") yields 200% in Excel. Use Number.ToText in PQ with different format options.