Dax help in SWITCH

[Anonymous]

Experts, please help me to fix the below DAX.

Type Description =

SWITCH(

'Accrual View'[Type]=11, "Carry Forward",

'Accrual View'[Type]=2, "Earned",

'Accrual View'[Type]=1, "Sick", 'Accrual View'[Type])

[Anonymous · Accepted solution]

Hi @Anonymous ,

1.Assume the Type columm is Number type, please try:

Type Description = 
SWITCH (
    TRUE (),
    'Accrual View'[Type] = 11, "Carry Forward",
    'Accrual View'[Type] = 2, "Earned",
    'Accrual View'[Type] = 1, "Sick",
    CONVERT( 'Accrual View'[Type],STRING)
)

2. Text type:

Description =
SWITCH ( [Type], "1", "Sick", "2", "Earned", "11", "Carry Forward", [Type] )

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi,

If you are trying to create a new column, please try something like below.

Type Description =
SWITCH (
    TRUE (),
    'Accrual View'[Type] = 11, "Carry Forward",
    'Accrual View'[Type] = 2, "Earned",
    'Accrual View'[Type] = 1, "Sick",
    'Accrual View'[Type]
)

[Anonymous]

Thanks @Jihwan_Kim But it is erroring out again, please help @amitchandak 

[FreemanZ]

hi @Anonymous @what type of data do you have for the [type] column

[Anonymous]

It was Number, I changed to text.

[FreemanZ]

the code compares it with number, so it needs to be numbers.