Formula for a new measure

[tbobolz]

Hi all, I have Excel 2010 on XP.

I have tried to search for this solutionbut can not find it.

I have a column in my powerpivot titled "DISCHARGE - FISCAL YEAR". In the pivot table I have this field in the column label so it returns 2013 then 2014 values. I want to add a new measure that creates a variance field in the column labels that simply subtracts these two values. Similar to our old calculated field: however, I can not get the formula correct as i am somewhat new to PP.

Here's the formula that I obviosly have wrong, but I am not sure how to define the column label to subtract 2013 from 2014. =[DISCHARGE - FISCAL YEAR]=2014-[DISCHARGE - FISCAL YEAR]=2013

Thanks for any education you can offer me.

Terry

 

[tbobolz]

Thanks all for the help, I have calculated a column, but was hoping to learn more about measurements, I ordered the DAX training manual from mrexcel, so hopefully it will teach me a lot.

Take care!

 

[miguel.escobar]

SUP!

try SUMX(the table where those columns are located, [column1] - [column2])

Hope this helps!