Forum Discussion
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.
| 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
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
4 Replies
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
I'm sure you're right, but unfortunately the formula isn't working as it should.
Do I have a syntax error?
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 😉
