Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 |
Hi @narangsumit0 ,
It's still not clear, can you explain how to get 23,0,31? Provide a formula to solve the problem faster.
Thanks for replying. Hope this would help understanding.
@narangsumit0 , Not very clear, can you explain it. Also, I do not see any cost element
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.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
182 | |
86 | |
67 | |
62 | |
53 |