VBA code to change Power pivot table data model

[aakkaarr]

In the attached file I recorded a macro to create pivot table
existing sheet is data

Then i added calculated column in data model in manage data model
Then again recorded macro to work on pivot table

The adding of calculated column is not recorded so i need VBA code to add column in data model

 

[Chihiro]

As far as I know, PowerPivot Model Object Model for VBA is to create and manage relationships.

The object model has only few Read/Write property (such as ModelMeasures.Add, Connection status etc).

See link.
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/about-the-powerpivot-model-object-in-excel

 

[aakkaarr]

Thanks
I you come across with some other solution pls update me

 

[Chihiro]

Only alternative that I can think of is to use ADO to take advantage of SQL Query and do your calculation in query, before data is loaded to model.

Have a read of...
https://powerpivotpro.com/2014/07/adding-tables-to-a-model-from-vba-in-excel-2013/

 

[aakkaarr]

Thanks but I feel this thread should remain open

 

[Chihiro]

? I'm not closing thread.

 

[aakkaarr]

Thanks