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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
AlessandroBet
Helper V
Helper V

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

3 REPLIES 3
AlessandroBet
Helper V
Helper V

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





PijushRoy
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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