Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Best way to transform column data

I have a column of data that has mutliple formats for what is supposed to represent %, see below.  What is the best way to transform them to all be valid %.  Assume this may entail multiple transform...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    How about adding a new calculated column as

     

    =if([Column1]<1,[Column1],[Column1]/100)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous,

 

By the way, to display the number as a percentage, you may use FORMAT or select Percentage format under Modeling tab.

Anonymous's avatar
Anonymous
Not applicable
7 years ago
thanks. The challenge wasn’t formatting to percent. When I change formatting it shows some as 1000% and some as 100% because the raw data was 100 in some rows and 1 in others.