Forum Discussion
Solved
Convert number into %
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)& "%"?
2 is 200%, not 2% and TEXT(2, "0%") yields 200% in Excel. Use Number.ToText in PQ with different format options.
2 is 200%, not 2% and TEXT(2, "0%") yields 200% in Excel. Use Number.ToText in PQ with different format options.