Check if number is between statement

[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

[az38 · Accepted solution]

Hi @qwertzuiop 

is it ok?

Column = IF(
[Column] > 3 && [Column] < 22,
"NoBreak",
"Break"
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

[qwertzuiop]

I'm sure you're right, but unfortunately the formula isn't working as it should.

Do I have a syntax error?

[NikoMendez]

Hi,

2 things ..

1st : the "=" sign is written twice at the beginning of the colomun expression

2nd : make sure that [timeOfCreationInNumber] has a number format otherwise because PBI is not able to compare numbers with strings. check in Power query if change is possible or in PBI, use VALUE([timeOfCreationInNumber])

Hope it helps 😉

[qwertzuiop]

Thank you very much.

It works now.