The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
75 | |
70 | |
40 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |