Calculate the difference between two columns in a matrix

[paulvu0911]

Hello,

I'm trying to create a table like this Power BI. Each row is a measure that I've built in Power BI, and the column represents the categories of the data item. However, I have a hard time creating the "Difference Column" to calculate the difference of each measure between "Sales" and "Contract". Is there a way in Power BI that I can create a column for "Difference"?

Thank you very much.

	April-18
	Sales	Contract	Difference
Loan Ct:	555
UPB:	$        100,000,000.95
Avg Loan Amt:	$             236,134	$             287,145	$           (51,011)
WAC	4.809	4.150	0.659
wAvg LTV:	79.6	72.6	7.0
wAvg FICO:	743	747	-4
Escrow%:	92%	50%	43%
Purchase %:	76%	38%	38%
OO %:	86%	86%	0%
CA%:	26%	68%	-42%

[v-qiuyu-msft]

Hi @paulvu0911,

Would you please share a pbix file with some dummy data for us to test it? 

Best Regards,
Qiuyun Yu 

[Trudgeon]

@paulvu0911 

Did you ever find a solution for this?  I'm trying to accomplish the same thing.

[paulvu0911 · Accepted solution]

I found something here.

https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185

Hope that helps

[Trudgeon]

Thanks!  I'll check it out.