Your first table choice in Power Pivot will haunt you - or how to set the default table name
In Excel 2013 the way to add Calculated fields changed a bit from the first version. Now you click Power Pivot tab and click Calculated Fields and New Calculated Field. I preferred the old method where I could right click in the Power Pivot fields list and add or modify the measure directly to a table.
Read more...