Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |