Hi, 

I have an old model that unfortunately had to be re-establish. 

In order to save time, I thought that I can export all my measures and paste it as measures in my new model. 

I used the following technique to export the measures from the old file:

http://www.powerpivotpro.com/2012/10/other-better-ways-to-get-all-measures-as-text/

Does anyone know how to use the output and create the identical measures in my new model, without the need to manually write each one of them?

Thanks

• Edited by 20 hours 38 minutes ago

You can copy/paste them in one by one. No other way I know of.

You should be able to connect to your Power Pivot model via AMO. You could use C# to connect to your model and then programmatically create your measures. See the following two links:

https://tabularamo2012.codeplex.com

http://stackoverflow.com/questions/8242557/connecting-to-powerpivot-with-c-sharp