How do I have a categorical variable from integer to text form in Power BI. For example, I have Gender coded as 1 = Male, 2 = Female. How do I change these in Power BI from 1, and 2 to “Male” and “Female” without having to revert back to excel?
This can be achieved with a Calculated Column using DAX.
ColumnName = IF(TableName[GenderCode] = 1, “M”, “F”)
Thank you! Do you mean I have to create a new measure or a new Column?
Please create a new column,