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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AlessandroBet
Resolver I
Resolver I

Segmentation

Hi,

 

i have a table with 2 columns (Client name, Saleprice)

i need to add a new column "Segmentation" that it takes the parameter from Min and Max and put the value A, B, C and D from the table below

Screenshot 2023-12-01 162133.png

 

EX: of new table with new column

 

Client Name    Sales Price    Segmentation

AAAA               1200             B

BBBB                 500              A

CCCC                7500             D

 

Many thanks

1 ACCEPTED SOLUTION

Hi @AlessandroBet 

The previous code will work, because when you use >= , it will show you proper data 
or try below code, here I have mentioned both range. Please change range as per your requirement

= if [Sales Price] >= 5000 and <= 9999.9999 then "D" else if [Sales Price] >= 3000 and <= 4999.9999 then "C" else if [Sales Price] >= 1000 and <= 2999.9999 then "B" else "A"

 

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

View solution in original post

3 REPLIES 3
AlessandroBet
Resolver I
Resolver I

Thanks but i have to set 2 paramiters Min and Max and not only 1

Hi @AlessandroBet 

The previous code will work, because when you use >= , it will show you proper data 
or try below code, here I have mentioned both range. Please change range as per your requirement

= if [Sales Price] >= 5000 and <= 9999.9999 then "D" else if [Sales Price] >= 3000 and <= 4999.9999 then "C" else if [Sales Price] >= 1000 and <= 2999.9999 then "B" else "A"

 

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

PijushRoy
Community Champion
Community Champion

Hi @AlessandroBet 

If the Parameter table is fixed and parameter data are not changing 
Then you can create a custom column in your second table with name Segmentation in use the below code

= if [Sales Price] >= 5000 then "D" else if [Sales Price] >= 3000 then "C" else if [Sales Price] >= 1000 then "B" else "A"

 
Let me know if it solve your requirement

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.