Forum Discussion

Sylvie_in_France's avatar
Sylvie_in_France
Brass Contributor
Jan 05, 2023

Power Pivot, measures, VBA - ModelMeasure class

Hi everybody,

I've been faced too many times with issues when I modify a query loaded into the Data Model. Sometimes it's really impossible to recover. The only solution is to copy-paste all the queries in another workbook and rebuild the measures and pivot tables.

To simplify that task, I've developed a set of macros to export and import the measures with the associated format. If anyone is interested, I can share them.

 

I use the classes Model, ModelMeasures, ModelMeasure, ModelTable, etc.

Two points are not solved: 

  1. The ModelMeasure.Description property doesn't work, neither read nor write
  2. The DecimalPlaces of the FormatInformation object can be retrieved but can't be set

Someone has managed to use those properties?

Thanks

 

No RepliesBe the first to reply

Resources