Home

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
ralechuga
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
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

@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies