Moving Calculated Fields

[bigck2]

Hello,

I am wondering if there is functionality in PowerPivot to get a view of all the calculated fields I have created. I would like to be able to get a summary of all the fields and the formulas without having to open each one up individually.

Also, would it be possible to copy the calculated fields to use in a different model. Some kind of import/export of calculated fields.

Thanks,

Chris

 

[theBardd]

You should be able to see them in the Power Pivot application if you open up the tab of the table that you assigned the measures to.

 

[ImkeF]

With DAX Studio, you can create very nice lists of your measures:

Other (Better) Ways to Get All Measures As Text « PowerPivotPro

Copy and paste from there into a new workbook is then done very quickly.

Imke

 

[GDRIII]

I use DAX Studio as well and then, use a CONCATENATE to recreate the full measures so they are copy/paste-able and store in a formula workbook.

 

[scottsen]

Partial solution, but if you are good w/ VBA, you can probably use this as a start: Power Pivot Data Dictionary in VBA | Tiny Lizard