create a calculated column that returns a specific string between to numbers

[qwertzuiop]

Dear PowerBI Community

First of all: Good luck for 2020!

I have the following question:

I want to create a calculated column that returns me a specific string.

IF

0	Break
1	Break
2	Break
3	Break
4	NoBreak
5	NoBreak
6	NoBreak
7	NoBreak
8	NoBreak
9	NoBreak
10	NoBreak
11	NoBreak
12	NoBreak
13	NoBreak
14	NoBreak
15	NoBreak
16	NoBreak
17	NoBreak
18	NoBreak
19	NoBreak
20	NoBreak
21	NoBreak
22	Break
23	Break

Anyone can help me?

Thank you so much for your help.

Cheres!

qwertzuiop

[Anonymous · Accepted solution]

Hi @qwertzuiop 

New Column = IF(Customer[Sales] <= 3,"Break",

IF(Customer[Sales] >3 && Customer[Sales]<22,"No Break","Break")

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.