Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
qwertzuiop
Advocate III
Advocate III

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors