Excel Pivot Calculated Fields from Same Colum

%3CLINGO-SUB%20id%3D%22lingo-sub-612579%22%20slang%3D%22en-US%22%3EExcel%20Pivot%20Calculated%20Fields%20from%20Same%20Colum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-612579%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20data%20table%20which%20has%20a%20column%20named%20%22Year%22%20which%20includes%202019%2C%202018%2C%202017.%20I%20want%20to%20create%20a%20calculated%20field%20called%20growth%20which%20divides%202019%2F2018%20but%20I%20only%20find%20the%20field%20year%20and%20not%20the%20detail%20of%20the%20column.%20What%20can%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-612579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615282%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Calculated%20Fields%20from%20Same%20Colum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615282%22%20slang%3D%22en-US%22%3EIf%20you%20have%20Excel%202016%20you%20could%20load%20your%20data%20to%20the%20Data%20Model%20and%20then%20write%20a%20DAX%20formula.%20This%20happens%20with%20Power%20Pivot.%20Have%20you%20got%20Excel%202016%20(or%20you%20can%20get%20an%20addin%20for%20Excel%202013)%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EDAX%20formulas%20are%20more%20flexible%20and%20powerful%20then%20the%20older%20Calculated%20items%2Ffields%20in%20Pivot%20Tables%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615347%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Calculated%20Fields%20from%20Same%20Colum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%2Cas%20a%20comment%2C%20that's%20not%20necessary%20to%20have%20Power%20Pivot%2C%20DAX%20measure%20could%20be%20added%20from%20PivotTable%20interface%20if%20data%20is%20added%20to%20data%20model.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a data table which has a column named "Year" which includes 2019, 2018, 2017. I want to create a calculated field called growth which divides 2019/2018 but I only find the field year and not the detail of the column. What can I do?

2 Replies
Highlighted
If you have Excel 2016 you could load your data to the Data Model and then write a DAX formula. This happens with Power Pivot. Have you got Excel 2016 (or you can get an addin for Excel 2013) ?

DAX formulas are more flexible and powerful then the older Calculated items/fields in Pivot Tables
Highlighted

@Wyn Hopkins ,as a comment, that's not necessary to have Power Pivot, DAX measure could be added from PivotTable interface if data is added to data model.