Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am loading my data directly from Oracle Database. I have a column called Gender which takes values 'M' and 'F'. However, I want to change all M to Male and F to Female without creating any additional column for gender.
How can this be done? Thank you!
Solved! Go to Solution.
Hi @Anonymous,
To clarify, do you mean Import or actual DirectQuery?
If you're using Import, just Replace Values in Query Editor to change M to "Male" and F to "Female."
Hi @Anonymous,
To clarify, do you mean Import or actual DirectQuery?
If you're using Import, just Replace Values in Query Editor to change M to "Male" and F to "Female."
@RMDNA Hey this worked. I also created a column with examples and deleted the original column