Switch True where input is number and output is text

[RK_JOB]

Hello,

I am getting an error in the formula. I am creating a calculated column in Tabular Editor with Switch True. 

Discount Depth is number.

 I tried it this way:

1. 

Discount Depth Group =
SWITCH (
TRUE (),
'Price Levels'[Discount Depth] >= 60, "70%",
'Price Levels'[Discount Depth] > 40, "50%",
'Price Levels'[Discount Depth] >= 25, "30%",
'Price Levels'[Discount Depth] >= 0, "0-25%",
"Not"
)
)

Or this way:

2. Discount Depth Group =
SWITCH (
TRUE (),
'Price Levels'[Discount Depth] >= 60, "70%",
'Price Levels'[Discount Depth] > 40, "50%",
'Price Levels'[Discount Depth] >= 25, "30%",
'Price Levels'[Discount Depth] >= 0, "0-25%"
), "Not"
)

What could be wrong?

Thanks in advance,

RK

[amitchandak]

@RK_JOB , Simply this one should work

Discount Depth Group =
SWITCH (
TRUE (),
'Price Levels'[Discount Depth] >= 60, "70%",
'Price Levels'[Discount Depth] > 40, "50%",
'Price Levels'[Discount Depth] >= 25, "30%",
'Price Levels'[Discount Depth] >= 0, "0-25%",
"Not"
)