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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DylanBanINT
Helper I
Helper I

Percentage calculation based off of a range of numbers

Hi, I am looking to create a column on Power BI that will calculate a percentage of a number based on the 'score' it has so that it will create an 'expected savings' 

 

For example I have a table like this: 

 

TitleScoreAmountSavings
Cookie40£100 
Cake60£50 
Sprite20£60 
Cola0£250 
Bread100£180 
Baguette60£40 
Slurpie40£55 
Green Tea20£180 

 

Based off the score I would like to calculate a percentage of 'savings' - If it has a score of 100 it will calculate 10% and if it has a score of 60 it will calculate 6% etc etc

1 ACCEPTED SOLUTION
5 REPLIES 5
DylanBanINT
Helper I
Helper I
amitchandak
Super User
Super User

@DylanBanINT , Create a new column

 

= [Amount] /10

Hi would this not just divide all amounts by 10? 

@DylanBanINT ,

You can create a new column like

 

 

Switch( True(),

[Amount] = 100, .1 ,

[Amount] =  60, .06 ,

0

)

 

Modify as per need

Hi, is there a way to do it so it would be like if Score is 0-100 then Amount / 0-10%? So like a range

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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