Forum Discussion

qwertzuiop's avatar
qwertzuiop
Advocate III
6 years ago
Solved

create a calculated column that returns a specific string between to numbers

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
0Break
1Break
2Break
3Break
4NoBreak
5NoBreak
6NoBreak
7NoBreak
8NoBreak
9NoBreak
10NoBreak
11NoBreak
12NoBreak
13NoBreak
14NoBreak
15NoBreak
16NoBreak
17NoBreak
18NoBreak
19NoBreak
20NoBreak
21NoBreak
22Break
23Break

 

Anyone can help me?

Thank you so much for your help.

 

Cheres!

qwertzuiop

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi qwertzuiop 

     

    New Column = IF(Customer[Sales] <= 3,"Break",
    IF(Customer[Sales] >3 && Customer[Sales]<22,"No Break","Break")
     
    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi qwertzuiop 

     

    New Column = IF(Customer[Sales] <= 3,"Break",
    IF(Customer[Sales] >3 && Customer[Sales]<22,"No Break","Break")
     
    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.