- 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

Subtraction the column in a visual
I have the following table (1) showing my expenses against each vendor. Now I have created a table in Power BI showing this (2) by putting "Cost Centers" in rows, "Vendor Name" in Columns and "Invoice" in Values. Now I want to know potential savings (negotaition) opportunity with the vendors by knowing the leader in price (lowest cost vendor) to us. Can you please help me how can I get the result which is in (3). I will appreciate the help. Thanks
(1)
Toli X | A | 21 |
Voice | B | 11 |
Scoot | C | 56 |
Scoot | A | 18 |
Scoot | B | 16 |
Voice | A | 21 |
Toli X | B | 48 |
Scoot | A | 56 |
Toli X | C | 89 |
Voice | B | 74 |
Actto | B | 70 |
Actto | C | 58 |
Actto | A | 49 |
Toli X | B | 86 |
Voice | C | 63 |
(2)
Toli X | Voice | Scoot | Actto | |
Cost Centers | 244 | 169 | 146 | 177 |
(3)
Difference from Leader | ||||||||
Toli X | Voice | Scoot | Actto | Toli X | Voice | Scoot | Actto | |
Cost Centers | 244 | 169 | 146 | 177 | 98 | 23 | 0 | 31 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @narangsumit0 ,
It's still not clear, can you explain how to get 23,0,31? Provide a formula to solve the problem faster.
If this post helps, then please consider Accept it as the solution to help the other members find it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for replying. Hope this would help understanding.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@narangsumit0 , Not very clear, can you explain it. Also, I do not see any cost element
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Cost element is cost center (A,B,C) which is the second header to table 1. I created a table visual in power BI using my own table. Now I want to create one more column in the same visual which will take the minium of three vendor cost center and subtract with each customer cost center to show an opportunity for savings.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-30-2024 07:42 AM | |||
10-10-2024 04:55 PM | |||
Anonymous
| 06-25-2024 07:48 AM | ||
12-14-2023 03:45 AM | |||
Anonymous
| 09-29-2022 02:37 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |