Forum Discussion

qwertzuiop's avatar
qwertzuiop
Advocate III
6 years ago
Solved

Check if number is between statement

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 Br...
Need Help
  • az38's avatar
    az38
    6 years ago

    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's avatar
qwertzuiop
Advocate III
6 years ago

 

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

Do I have a syntax error?

NikoMendez's avatar
NikoMendez
Frequent Visitor
6 years ago

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's avatar
    qwertzuiop
    Advocate III
    6 years ago

    Thank you very much.

    It works now.