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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
75 | |
72 | |
48 | |
47 |
User | Count |
---|---|
160 | |
85 | |
80 | |
68 | |
66 |