Power Pivot - Created Measures/Existing Measures

%3CLINGO-SUB%20id%3D%22lingo-sub-2500520%22%20slang%3D%22en-US%22%3EPower%20Pivot%20-%20Created%20Measures%2FExisting%20Measures%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2500520%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20am%20new%20to%20the%20power%20pivot%20concept.%20I%20have%20query%20regarding%20Power%20pivot%20measure.%20I%20have%20few%20excels%20in%20which%20I%20have%20many%20pivot%20tables%20in%20each%20tab.%20they%20are%20around%206%20in%20each%20tab.%20for%20some%20pivot%20table%20I%20am%20filtering%20data%20by%20YTD%20and%20some%20pivot%20by%20rolling%20back%206month%20and%20rolling%20back%2012month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20create%20measure%20for%20these%20criteria%20in%20power%20pivot%20since%20earlier%20i%20have%20to%20select%20criteria%20manually%20each%20month%20for%20all%20this%20pivots.%20the%20measure%20created%20can%20only%20be%20applied%20to%20new%20pivots%20not%20existing%20one's.%3C%2FP%3E%3CP%3EIt%20will%20take%20a%20lot%20time%20to%20create%20new%20pivots%20by%20replicating%20old%20ones.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20any%20one%20is%20having%20solution%20for%20these%20as%20it%20will%20save%20lot%20of%20time%20in%20days%20if%20we%20are%20able%20to%20apply%20the%26nbsp%3B%20measure%20in%20power%20pivot%20to%20existing%20normal%20pivots%20tables%20in%20excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2625784%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20-%20Created%20Measures%2FExisting%20Measures%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091708%22%20target%3D%22_blank%22%3E%40Mrunal_M%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20depends%20on%20if%20you're%20using%20classic%20PIVOT%20TABLES%20or%20using%20DATA%20MODEL%20based%20PIVOT%20TABLES.%26nbsp%3B%20Mr%20Sergei%20Baklan%20is%20the%20expert%20at%20this.%26nbsp%3B%20You'll%20have%20to%20share%20your%20dataset%2FWorkbook%20for%20this%20complex%20question%2C%20and%20although%20you%20might%20creating%20explicit%20measures%2C%20in%20DAX%20FUNCTIONS%20has%20built%20in%20implicit%20processes%20that%20exist%20depending%20on%20which%20functions%20you%20are%20using%20in%20your%20explicit%20measure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

Hi All,

I am new to the power pivot concept. I have query regarding Power pivot measure. I have few excels in which I have many pivot tables in each tab. they are around 6 in each tab. for some pivot table I am filtering data by YTD and some pivot by rolling back 6month and rolling back 12month.

 

I tried to create measure for these criteria in power pivot since earlier i have to select criteria manually each month for all this pivots. the measure created can only be applied to new pivots not existing one's.

It will take a lot time to create new pivots by replicating old ones.

 

Is any one is having solution for these as it will save lot of time in days if we are able to apply the  measure in power pivot to existing normal pivots tables in excel.

1 Reply

@Mrunal_M , @Sergei Baklan 

 

That depends on if you're using classic PIVOT TABLES or using DATA MODEL based PIVOT TABLES.  Mr Sergei Baklan is the expert at this.  You'll have to share your dataset/Workbook for this complex question, and although you might creating explicit measures, in DAX FUNCTIONS has built in implicit processes that exist depending on which functions you are using in your explicit measure.

 

Cheers