topic Turn % into a Whole Number in DAX Commands and Tips

Turn % into a Whole Number

e175429 — Thu, 13 Apr 2023 16:29:00 GMT

Hello All,

I am trying to show a NPS score. When I enter the inital calculations, it gives me a %. How do I turn this into a whole number to just say -27?

When I change "Percentage" to "Whole Number" I get:

Which confuses me even more

Re: Turn % into a Whole Number

DOLEARY85 — Thu, 13 Apr 2023 21:11:59 GMT

Hi,

transforming a percentage to a number will always show 0 unless it's 100% then it will be 1. If you add some decimal places to the number you should see that 27% is 0.0027

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Re: Turn % into a Whole Number

tamerj1 — Thu, 13 Apr 2023 21:15:34 GMT

Hi e175429

Just muliply by 100 and change the data type to integer