Need to convert (Yes/No) to 1/0

[ch_01]

Hi, 

I have a column Churn where the values are Yes/No need to be converted as 1 & 0 (Yes=1 , No=0).  Can anyone assist me?

[ribisht17 · Accepted solution]

  Hi @ch_01 

Refer >> How to replace values in power bi (projectpro.io)

Step 1 - Select the data for replacing

Select the columns of the values you want to replace.

Step 2 - Select the Replace Values option

Right-click on the data set in the Fields pane, click on the edit query option. This will redirect us to Power Query Editor then follow the below steps -

Transform -> Replace Values button -> Replace Values Option

Replace Yes with 1 and No with 0

Step 3 - Insert Value to find(old) and value to Replace with(new)

After you click on the Replace Values option, a small window gets open where you can replace the old value with the new value.

Step 4 - Close and apply

Click on OK in the Replace Value window, it will replace the old value with the new value. Click on the Close & Apply button in order to apply all changes.

Regards,

Ritesh

@ch_01

[ch_01]

Thank you