Coding numbers in column to text

[cleolee123]

Hi all, I desperately need help in generating this code. My data is a survey excel sheet with about 10 questions each answer is a scale of 1 to 5 which stands for "very satisfied" to "very dissatisfied." However, when collecting data it only collects the numbers 1-5 but i want to generate reports that show the words "very satisfied" to "very dissatisfied". Is there a code that replaces all the "1" to "very satisfied" etc for all the questions at once since they use the same scale? Thanks in advance 

[harshnathani]

Hi @cleolee123 ,

You can use Query Editor function Replace.

Else you cna use the function

https://dax.guide/REPLACE/

https://www.tutorialspoint.com/dax_functions/dax_replace_function.htm

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[cleolee123]

Hi Harsh,

How can i input the replace code? Do i create a new column? Sorry as i am still new to this but thanks in advance 

[harshnathani]

Hi @cleolee123 ,

Click on Transform Data.

SELECT the Column whose Value you want to Replace.

Click on Replace Value. Enter the Value to Find and Repalce With.

Once Values are Replaced, Click Close and Apply.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[cleolee123]

Hi Harsh,

Thanks! Is there any way to code such that all the "1"s in all 300 questions are replaced with "very satisfied" without having to repeat this process for all 300 qns? Thanks!!!

[harshnathani]

Hi @cleolee123 ,

Create a Calculated Column

Replace =

SWITCH(

TRUE(),

Table[Value] = 1 , "Very Satisfied",

Table[Value] = 2 , "Satisfied",

Table[Value] = 3, "OK",

Table[Value] = 4, "Dissatisfied",

Table[Value] = 5, "Very Dissatisfied"

)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)