cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Percentage calculation based off of a number range

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:

 Title Score Amount Savings Cookie 40 £100 Cake 60 £50 Sprite 20 £60 Cola 0 £250 Bread 100 £180 Baguette 60 £40 Slurpie 40 £55 Green Tea 20 £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
Community Champion

Hi @DylanBanINT ,

Try this:

Expected saving = score/10

Eg- if score = 95/10 then expected savings would be 9.5

Please hit the thumbs up and mark it as a solution if it helps you. Thanks.

2 REPLIES 2
Community Champion

Hi @DylanBanINT ,

Try this:

Expected saving = score/10

Eg- if score = 95/10 then expected savings would be 9.5

Please hit the thumbs up and mark it as a solution if it helps you. Thanks.

Super User

@DylanBanINT , You can create a new column like

Switch( True(),

[Amount] = 100, .1 ,

[Amount] =  60, .06 ,

0

)

Modify as per need

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.