none
How can I add new calculated field in power pivot excel 2010?

    Question

  • Dears

     How can I add new calculated field in power pivot excel 2010?

    Like I want to divide two columns in my power pivot as the normal pivot table

    Saturday, March 02, 2013 9:07 PM

Answers

All replies

  • Hi Atefsaloma,

    Please refer to the following link:

    Create a Calculated Field in PowerPivot

    Good day.


    Yoyo Jiang[MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, March 05, 2013 11:22 AM
    Moderator
  • Hi Atefsaloma,

    I temporarily marked the reply as answer and you can unmark it if it provides no help.
    Please feel free to let us know if you have any concern.

    Thanks for your understanding and have a nice day.


    Yoyo Jiang[MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, March 13, 2013 11:33 AM
    Moderator
  • Hi this anwser-

    Applies to:

    Excel 2013, Power BI for Office 365 Preview, Power Pivot in Excel 2013

    Is there a 2010 excel solution. I have tried calculations in DAX, but most of the time the field is not allowed in the values filed when I attempt to drag it down within the pivot table.

    Thanks

    Terry

    Monday, October 28, 2013 3:05 PM
  • Is there any update on this? I am also facing the same issue with power pivot in excel 2010. Creating a new Calculated column is also not a suitable solution in my case.
    Monday, December 23, 2013 9:17 AM