Report Portal

Power Pivot Data Dictionary From VBA

he folks over at PowerPivotPro have blogged like. everything under the sun about Power Pivot. It's always a bit embarrassing to search for a technique like. the formula for a calculated column for "End of Week" date. and it turns out that *I* wrote it on PPP blog and forgot about it Smile. Anyway, I was starting this article and decided to do something crazy and search for it first. and naturally, they already have it blogged. Their technique is super fancy. This is so simple that it isn't even complete Smile with tongue out And it only works for 2013. though, I suspect 2010 maybe be a simple change.

Read more...

Tags: amo, tabular

 

2007-2015 VidasSoft Systems Inc.