Forum Discussion

narangsumit0's avatar
narangsumit0
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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 "Invoic...
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

narangsumit0 , Not very clear, can you explain it. Also, I do not see any cost element

narangsumit0's avatar
narangsumit0
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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.