Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
From edit queries, can I change all "1" to male and all "2" to female?
i know i can create a new column and change them by if function. but can i change them from the existing columns?
Solved! Go to Solution.
@Anonymous
1) in the Query Editor - select the column - Home tab - Data Type - change to Text
2) right-click on the column - Replace Values - 1 - Male
3) right-click on the column - Replace Values - 2 - Female
Good Luck!
Hi @Anonymous,
Just as @Sean posted, you can replace it in Power Query Edit as follows, please test it. If it resolve your issue, please mark the corresponding reply as answer, so other people can find the solution.
Best Regards,
Angelia
ust want to change one cell, but it changes all the same value. For instance, I want to change "2" to "4" in E5. But it changes all "2" in other rows as well.
So, how do you chnage values in specific cells?
@Anonymous
1) in the Query Editor - select the column - Home tab - Data Type - change to Text
2) right-click on the column - Replace Values - 1 - Male
3) right-click on the column - Replace Values - 2 - Female
Good Luck!
In the Query Editor, you can even click the data type icon in the column header (in this case, the "123" icon) and change to Text.
I just learned from the February 2017 Feature video about "Using Locale.." being added over there.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |