Gender

[Anonymous]

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?

[DimaMD · Accepted solution]

Hi @Anonymous  try it

SWITCH(
    TRUE(),
    OR([#] = 0, [#] = 2), "woman",
    OR([#] = 1, [#] = 3), "man",
    "etc"
)   

[Anonymous]

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 ?

[DimaMD · Accepted solution]

@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

[DimaMD · Accepted solution]

Hi @Anonymous  try it

SWITCH(
    TRUE(),
    OR([#] = 0, [#] = 2), "woman",
    OR([#] = 1, [#] = 3), "man",
    "etc"
)