Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Percentage calculation based off of a range of numbers
08-22-2022
07:17 AM
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
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022
04:42 AM
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022
04:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022
01:00 AM

Hi would this not just divide all amounts by 10?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022
02:02 AM

You can create a new column like
Switch( True(),
[Amount] = 100, .1 ,
[Amount] = 60, .06 ,
0
)
Modify as per need
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022
02:08 AM

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
Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-04-2025 09:36 PM | |||
04-06-2025 06:53 AM | |||
09-24-2024 12:22 PM | |||
07-08-2025 08:59 AM | |||
07-10-2025 02:39 PM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |