Replace Values in Data Column

[dtango9]

Hello,

I currently have a column in my dataset with values of the following:

100000000 = Not at all satisfied
100000001 = Slightly satisfied
100000002 = Moderately satisfied

100000003 = Very satisfied

100000004 = Completely satisfied

I would like to replace those values to now become numbered on the 1-5 scale instead of the long string.

100000000 = 1
100000001 = 2
100000002 = 3

100000003 = 4

100000004 = 5

Can anyone help me with this?  Thanks in advance.

[negi007 · Accepted solution]

@dtango9 The easiest thing is to make changes in the power query window so that you have updated the information on your powerbi desktop. This will also not put extra load on the dataset as changes are made before loading data into power bi desktop. Below is the screnshot of the powerquery window where you can make changes.

[amitchandak]

@dtango9 , Create a new column like

Switch( [Column],
100000000 , 1,
100000001 , 2,
100000002 , 3,

100000003 , 4,

100000004 , 5)