cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paulvu0911 Frequent Visitor
Frequent Visitor

Calculate the difference between two columns in a matrix

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
 SalesContractDifference
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.672.67.0
wAvg FICO:                        743747-4
Escrow%:92%50%43%
Purchase %:76%38%38%
OO %:86%86%0%
CA%:26%68%-42%
1 ACCEPTED SOLUTION

Accepted Solutions
paulvu0911 Frequent Visitor
Frequent Visitor

Re: Calculate the difference between two columns in a matrix

4 REPLIES 4
Moderator v-qiuyu-msft
Moderator

Re: Calculate the difference between two columns in a matrix

Hi @paulvu0911,

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Trudgeon Regular Visitor
Regular Visitor

Re: Calculate the difference between two columns in a matrix

@paulvu0911 

 

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

paulvu0911 Frequent Visitor
Frequent Visitor

Re: Calculate the difference between two columns in a matrix

Trudgeon Regular Visitor
Regular Visitor

Re: Calculate the difference between two columns in a matrix

Thanks!  I'll check it out.