Forum Discussion
Replace Values in Data Column
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.
@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.
2 Replies
dtango9 , Create a new column like
Switch( [Column],
100000000 , 1,
100000001 , 2,
100000002 , 3,100000003 , 4,
100000004 , 5)
@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.
