take difference columns power pivot

[daveyc18]

Loading Google Sheets

sample data...trying to take diff between amount and amount 2 row by row and add it as another column in the pivot ...let's call it "difference"

calculated field is grayed out since i assume it's power pivot

using DAX would be fine as well..I'm indifferent

 

[RoryA]

On the Power Pivot tab, click the Measures drop down, New measure, then call it whatever you like and use the formula:

=[Sum of Amount]-[Sum of Amount 2]

 

[daveyc18]

On the Power Pivot tab, click the Measures drop down, New measure, then call it whatever you like and use the formula:

=[Sum of Amount]-[Sum of Amount 2]

tks

what if it's like this

Loading Google Sheets

possible to make a measure or something else so i can achieve what's in column o and p so that it's "integrated " with the pivot instead of formulas ?