Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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 😉
Thank you very much.
It works now.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
66 | |
64 | |
52 | |
39 | |
25 |
User | Count |
---|---|
80 | |
57 | |
45 | |
44 | |
35 |