Forum Discussion
Gender
Hello !
I need help categorizing different numbers that tell what gender it is.
Ex:
0, woman
1, man
2, woman
3, man
etc
Is there any good way to create a new variable for it?
Hi Anonymous try it
SWITCH( TRUE(), OR([#] = 0, [#] = 2), "woman", OR([#] = 1, [#] = 3), "man", "etc" )Anonymous See also this file, I optimized the measure and gave 2 examples
Hello again!
I don't really know what I'm doing wrong, but it doesn't seem to work, I've tried several different options
Gender2 = SWITCH(TRUE(),
OR(Data_renter[Gender_number] = 0, Data_renter[Gender_number]=2), "Female",
OR(Data_renter[Gender_number] = 4, Data_renter[Gender_number]=6), "Female",
OR(Data_renter[Gender_number] = 8, Data_renter[Gender_number]=10), "Female",
OR(Data_renter[Gender_number] = 1, Data_renter[Gender_number]=3), "Male",
OR(Data_tenant[Gender_number] = 5, Data_tenant[Gender_number]=7), "Male",
OR(Data_renter[Gender_number] = 9, Data_renter[Gender_number]=11), "Male")
What am I doing wrong ?
DimaMDSolution Sage
Anonymous See also this file, I optimized the measure and gave 2 examples
- DimaMD
Hi Anonymous What is the data type in the column? text or numeric?
Show the error you are getting, preferably with a screenshot
look at the attached file, maybe you will understand where you made a mistake