posts by xuyuzhu

VIEWS: 3 PAGES: 28

									  2
 22
 34
 49
 50
 51
 56
 69
 71
 78
 79
 80
 87
109
110
119
120
131
132
145
150
159
163
176
196
218
340
348
390
469
471
477
534
535
566
568
569
571
584
597
614
616
617
626
627
628
635
639
640
643
648
651
653
654
657
659
666
678
683
684
687
689
691
692
698
715
731
740
759
767
777
783
808
811
833
862
868
873
883
884
887
889
895
901
902
907
908
909
915
926
930
941
963
968
 971
1005
1008
1011
1030
1052
1080
1083
1089
1094
1104
1108
1118
1128
1151
1154
1155
1166
1169
1191
1197
1222
1254
1265
1274
1282
1283
1284
1290
1291
1319
1295
1433
1436
1445
1460
1472
1477
1481
1515
1518
1533
1537
1540
1547
1554
1558
1561
1565
1594
1597
1600
1604
1608
1617
1622
1609
1640
1645
1656
1654
1688
1679
1693
1699
1700
1725
1740
1754
1756
1765
1770
1775
1777
1803
1804
1840
1848
1869
1871
1829
1883
1888
1892
1922
1947
1951
1963
1974
1975
1983
1988
1995
1989
2002
2005
2008
2018
2035
2039
2040
2044
2048
2051
2056
2057
2062
2080
2087
2100
2103
2120
2121
2126
2131
2132
2146
2180
2189
2199
2223
2237
2247
2249
2254
2261
2277
2284
2301
2307
2325
2339
2341
2359
2369
2383
2395
2429
2441
2443
2452
2456
2469
2478
2487
2500
2514
2529
2548
2558
2575
2589
2607
2611
2614
2621
2626
2641
2646
2649
2651
2668
2669
2670
2671
2672
2673
2674
2678
2679
2681
2721
2685
2781
2712
2794
2779
2814
2824
2715
2882
2701
2886
2887
2897
2913
2971
2975
2926
3034
3058
2992
3106
3076
3140
3145
3148
3156
3157
2960
3161
3117
3163
3195
3202
3207
3247
3256
3218
3224
3266
3271
3288
3314
3318
3343
3448
3465
3409
3491
3503
3509
3620
3647
3532
Meet The Pros
Hello Everybody…
Announcing the Great Football Project
Forgot to mention…
What is PowerPivot?
What is PowerPivot?
US Meteorological Data
SharePoint Conf 2009: Five Observations
I have my work cut out for me…
Football data source tables
SharePoint Conf 2009: Observations #2 and #3
PowerPivot’s impact on BI pros?
Football: loading the data
Better image sizes
PowerPivot ranked #1 favorite feature from SharePoint conf
Honk if you hate site previews!
Article on Enterprise BI Mashups
PowerPivot Data Cleaning: Three Options (with a football angle of course)
Excel team blog – great PowerPivot content
SP Conf 2009: Last Two Observations
Thank you Mariano!
Haunted by myself, circa 1996
SharePoint Samurai’s Surrational SharePoint Fairy
PowerPivot Football Project: The first DAX formulas, and Relationships
LinkedIn Poll on Excel BI Usage
Playing with theme again…
Relationships, Pivots, and DAX: The Payoff, Part One
Hiding fields from the field list in CTP3
Trusting the data…
Ohio-area PowerPivot summit?
PowerPivot DAX & Relationships Payoff, Part Two
Last night's video, attempt #2
Comments Links, and “No Question Left Behind―
Forrester Top 10 – The View From PowerPivot
PowerPivot - Better football project links
PowerPivot Beta (CTP3) Release Date?
Three new PowerPivot blogs :)
Sports fans use BI!
A 48 hour case study from Bing – Zero to Sixty :)
Darinee’s PowerPivot Adventure - Postscript
DAX: The =RELATED() Function
More Excel Services API Info
Does PowerPivot Need Office 2010 Deployed Everywhere?
Now THAT was bizarre…
Ugh
Temperature Mashup Example
Excel blog: Dashboard improvements
The temperature data from last night’s video
Introducing PowerPivot DAX Measures
PowerPivot Beta (CTP3) Tomorrow!
PowerPivot CTP3 (Beta) Download Links
Temperature Mashup Demo – Download the Workbook!
Good stuff from the Geek
Updated PowerPivot for SharePoint Install Steps
The Coming Week
New Visitor?
At last we meet, Samurai!
Fixed Version of the “Qty per Day―   Measure
Thank you
Kasper de Jonge Video
Why BI spending defies recessions
Back home tonight, PowerPivot content resumes
                                 in
Putting the “Intelligence” “Business Intelligence,” Part 1
Some recent PowerPivot links
Visualizing SQL Indices with PowerPivot
                                 in                         Pt
Putting the “Intelligence” “Business Intelligence,” 2
An oldie but a goodie: The Evil Pivot Wizard
DAX’s CALCULATE() function – Pivots will never be the same
                                 in                         Pt
Putting the “Intelligence” “Business Intelligence,” 3
Microsoft Unveils New Programming Language: XL#
PowerPivot DAX: CALCULATE is a supercharged SUMIF
PowerPivot.com Revamped
DAX CALCULATE, and Rapid Iteration
The anti-inspiration for PowerPivot UX
The death of pie charts?
Server Install Cheatsheets from PowerPivot Geek
The Great PowerPivot FAQ
More discussion on gauges
Give me good data or give me… um, good data
Cursed spam filter!
FAQ
PowerPivot for Science?
Touchdown Problem Solved, and COUNTROWS
The FAQ is now accepting applications!
More on visualization
Announcing our esteemed FAQ moderators!
Podcast with Ross McLean
Slicers and Multi-Touch!
Not your average PowerPivot report
Visitors Map
The bug count also rises
Mr. Excel joins FAQ moderation team
Pulling back the curtain: Intro to Cube Formulas
OMG It’s a Naked Donald Farmer!
PowerPivot for SharePoint Video
Parameterizing the report
Introducing CUBESET() and CUBERANKEDMEMBER()
Link to cube formulas spreadsheet fixed
Pivots, I have not forgotten ye!
Tommy Farmer? Donny Chong? A Photo Essay
PowerPivot Data in Scatter Charts, etc.
Espionage? Spam? Ravings of a lunatic?
Captain Ramius Returns!
Surprising Example of PowerPivot Compression
Dirty Swedish Video
A few new FAQ features
Calling for Guest Posts!
Jewelry Mashup for Alpha Geek Challenge
Quick Data Prep Trick: Use a Flat Pivot!
Captain Ramius: Epilogue
Use datamining with PowerPivot in Excel
Sweden: the full videos
DAX: I’ve been shortchanging you
SUMX() - The 5-point palm, exploding fxn technique
The Superheroes of DAX, and derived measures
Generating a Tag Cloud via PowerPivot
ALL() Revisited
Just call me Pivot… MC Pivot
Leaving Microsoft
Guest Post: Dany Hoter on Cube Formulas
Just joining us?
Minnesota in the morning
Excel Monkey Uprising! (and a Contest!)
Do you work for a sports team?
Writing a RANK measure (and living to tell the tale)
Down the rabbit hole: my new adventure revealed
Rank continued – dealing with unknown members
The Great Broken Links
Retailer Overlap Analysis Using PowerPivot
RANK measure finished
Two Observations
NotePad++
PowerPivot and Sparklines .. the easy way
Notepad++ and DAX - Guest Post from Colin Banfield
DAX.xml file from Colin
David Coe Wins Excel Monkey Contest
Quick Tip: Don’t Over-Use FILTER()
PowerPivot FAQ roadshow at SQLPass EU
Six Months With PowerPivot, part one
New Docs from Redmond!
PowerPivot v1 Released to MSDN!
PowerPivot Interest By Industry
May 12th in NYC: “IT Can’t Hide from MS Excel―
                                      XL
Automating the “Site Visitors― Report
I thought this was kinda cool…
I Risk Serious Bodily Injury vs. the Dutch Menace
Up for air… briefly
Pivotstream has a new logo
Kasper de Jonge joins PowerPivotPro!
The PowerPivot job posting I mentioned earlier
Building a cash flow statement in PowerPivot using dynamic measures in DAX
Review new PowerPivot workbooks on SharePoint using approval workflows
PowerPivot time intelligent functions: why use ALL() and how to work around it
Get insight to SharePoint PowerPivot usage without Central admin rights using custom SSRS reports
Calling a Stored procedure in PowerPivot
PowerPivot observations from TechEd/BI Conf, Pt 1
Welcome Query designers!
Use slicer values in a calculation with PowerPivot DAX
TechEd / BI Conference Slides
Using Excel CUBE Functions with PowerPivot
Quick tip: disable addin for rapid layout
PowerPivot field list and Excel field list at same time!
Slicers and pivot update performance
Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot
An XL Pro’s Plea for More XL Pro-Focused Content
Two Excellent PowerPivot Books
Win an MSDN Subscription - Free Software!
Where’s Waldo Contest – Two Hints!
The Most Tenacious Man in the World
PowerPivot Training/Consulting
Combine two data sources (in our case ssas) using PowerPivot
Two common PowerPivot error messages
Pivot Refresh vs. Update – is there a real difference?
Review: Prof. PowerPivot for Excel & SharePoint
Extranet Analytics Products Using PowerPivot!
Datamining using PowerPivot and Predixion Insight
PowerPivot VBA Macro Mania!
A few tips on maintainability
Cleaner SharePoint pages, and an offer to share
1,300 Measures – Nightmare or Utopia?
AVERAGEX - The 5-point palm, exploding fxn technique revisited
Interview with JamieMac of Predixion Software
Contest: Many Charts, Shared Slicers, Fast Queries
Contest Update
Customized SharePoint Report Portal
Top 5 Ways PowerPivot Helps Excel Pros
Illustrated guide to Excel Services Chart Rendering
Congratulations Kasper!
Added a Search Box
More PowerPivot Consulting Observations
PowerPivot Mind Meld: To Consult is to Train
                    of
The “Ferrari― PowerPivot Books
Add a “Last Refreshed Date―      Readout
Going to PASS? Track me down!
Psst… Sports League/Team… yeah, you…
OK… PowerPivot Green After All
Five Observations From SQL PASS
Learning DAX Measures – the “Spicy Function―      Scale
Time to Rename Traditional BI?
Thanksgiving thought: A BI Pro Reflects on Investing
Hardware/Capacity Planning: From the Trenches
PowerPivot for Excel 2007?
PowerPivot Refresh: CPU/RAM Spike at Completion
Another way to get and use slicer values in formulas
Santa’s Elven Productivity Simulator Leaked Online!
PowerPivot Scheduled Refresh – Twists & Turns, Pt 1
Speaking at SQL Saturday 60 – Cleveland
Donald Farmer Leaves MS for Qliktech / QlikView
The Tommy Chong Meme Spreads!
Quick Poll: Do you run PowerPivot for Excel on Win XP?
Data Refresh Twists/Turns Pt2 – Pivot Refresh
Campaign Analysis: Seasonally-Adjusted Measures
Got a high end CPU? Please help w/ an experiment!
Live in Europe? PowerPivot Workshop!
PowerPivot Scheduled Refresh Pt 3: Thin Workbooks
PowerPivot Accelerators: The Story (And Announcing: the Private Beta)
Is the future of Office too tightly tied to SharePoint?
Beta program update
Speaking at Columbus OH User Group Tonight!
James Bond, international biz intel operative
Date and Date/Time – Sneaky Data Types!
Buying a PowerPivot Server? Talk to Me First!
The Magic of IF(VALUES())
More Fun With IF(VALUES())
Guest Post: Catalog Your Measures with a Nifty Macro
Are you making daiquiris or blenders?
Advanced DAX calculation: doing a moving grouped average in PowerPivot
Announcing the Great PowerPivot Survey
Guest Post: Nth Occurrence DAX Formula
The Great PowerPivot Survey: Results Preview
Survey Results Part 2: Tech Pros vs. Excel Pros
A/B Campaign Analysis with Start & End Date Slicers
Guest Post: Calculating a Sum Based on a List Criteria
The Friendly Neighborhood Operators && and ||
Portable Formulas: An Underestimated Benefit
A Lesson in A-G-I-L-I-T-Y
HostedPowerPivot.com from Pivotstream & Rackspace
Three quick news updates
“These are my numbers. I make them go up.―
Two tips from “the Old Country―
The Great Precedence Project (Filter Rules for DAX)
Precedence Project Part Two: VALUES()
PowerPivot Hosting
Precedence Part 3: ALLEXCEPT vs. ALL w/ VALUES
Homer Simpson has more accurate computing than us
Running Totals Without a Traditional Calendar Table
PowerPivot V2 CTP3!
Guest Post: TOPN in PowerPivot V2
Couldn’t Resist… Parameterized PowerPivot Report!
Distinct Count in PowerPivot v2 – MUCH Faster
What color are Santa Claus’s Pants?
Less Columns, More Rows = More Speed!
Value Proposition of PowerPivot (in CIMA Insight)
SharePoint Saturday Columbus this Weekend
Rackspace Webinar from June
Home




New Server!
Guest Post - Greater Than/Less Than/Between Slicers
PowerPivot Refresh thru VBA at last!
Tuesday/Thursday Post Schedule – An Experiment
The Incredible “Iffer-Blanker-Filter” Measure
Blog Outage
Catching Multiple Slicer Selections in a Formula
CIMA Part 2 – The Hidden Costs of Traditional BI
Profit & Loss–The Art of the Cascading Subtotal
Profit & Loss–The Art of Cascading Subtotals Workbook
SQL Saturday 85, Orlando FL, September 24
Detecting ALL() - Detecting When Not Filtered
Mr. Excel Makes His HostedPowerPivot Site Public
DAX Autocomplete Stops Working–A Workable “Fix”
Slides from SQL Sat 85
Pivotstream is Hiring – SSIS/SQL Pros
Creating Accurate Percentile Measures in DAX – Part I
Creating Accurate Percentile Measures in DAX – Part II
PowerPivot ROI Comparison: CIMA Part Three
Friday Bonus: UFO Sightings & Hallucinogen Use
Slicers For Selecting Last "X" Periods
User-Friendly Report Sorting With Slicers!
Adding State Alpha Sort to the Sort By Slicer Trick
Profit & Loss (Part 2)–Compare and Analyse
Try Out Sort by Slicers, UFO’s, in Browser, No Login!
Profit & Loss (Part 3)–Return On Sales and Variances
SharePoint Saturday Cincy
Off Topic: Halloween Humor
What if spreadsheets were invented today?
Mini-Post 1 of 4: PowerPivot Pro Needed in Denmark!
Mini-Post 2/4: SQL Saturday Tampa this Wknd!
Mini-Post 3/4: DAX.xml Update for Notepad++ from Colin Banfield
Mini Post 4/4: Refreshing the FAQ, Recruiting New Contributors!
Trended Moving Averages
Six Observations from the 2011 PASS Keynote
The Ultimate Date Table
Comparing Access to PowerPivot
Why PowerPivot is Better Fed From a Database, Pt 1
Delayed today, but post still coming
Why PowerPivot is Better Fed from a Database, Pt2
SQL UNPIVOT Makes My Data Skinny
Using Query Editor to Create a Time Table
Friday Bonus: Excel Goes Gangsta!
The Greatest Formula in the World, Part One
The Greatest Formula in the World, Part Two
Friday Bonus: Gang Sign Photos So Far
The Greatest Formula in the World, Part 3
Cash Flow Statement in PowerPivot
On Break for Holidays. Next Post January 2nd!
Welcome to 2012: the Year of PowerPivot Everywhere
Switching Subtotals On & Off Dynamically Using DAX in PowerPivot
In the Browser, Aesthetics Yield a Greater Return
Sales/Budget: Integrating Data of Different “Grains”
Friday Bonus: 2012 *IS* the Year
Guest Post: 15 Spreadsheet Formatting Tips
Data of Different Grains: A Followup
Prepayments & Deferred Revenue
http://www.powerpivotpro.com/about/
http://powerpivotpro.wordpress.com/2009/10/26/hello-everybody/
http://powerpivotpro.wordpress.com/2009/10/27/announcing-the-great-football-project/
http://powerpivotpro.wordpress.com/2009/10/27/forgot-to-mention/
http://powerpivotpro.wordpress.com/2009/10/28/what-is-powerpivot/
http://powerpivotpro.wordpress.com/what-is-powerpivot/
http://powerpivotpro.wordpress.com/2009/10/28/us-meteorological-data/
http://powerpivotpro.wordpress.com/2009/10/28/sharepoint-conf-2009-five-observations/
http://powerpivotpro.wordpress.com/2009/10/28/i-have-my-work-cut-out-for-me/
http://powerpivotpro.wordpress.com/2009/10/29/football-data-source-tables/
http://powerpivotpro.wordpress.com/2009/10/29/sharepoint-conf-2009-observations-2-and-3/
http://powerpivotpro.wordpress.com/2009/10/29/powerpivots-impact-on-bi-pros/
http://powerpivotpro.wordpress.com/2009/10/29/football-loading-the-data/
http://powerpivotpro.wordpress.com/2009/10/29/better-image-sizes/
http://powerpivotpro.wordpress.com/2009/10/30/powerpivot-ranked-1-favorite-feature-from-sharepoint-conf/
http://powerpivotpro.wordpress.com/2009/10/30/honk-if-you-hate-site-previews/
http://powerpivotpro.wordpress.com/2009/10/30/article-on-enterprise-bi-mashups/
http://powerpivotpro.wordpress.com/2009/10/30/powerpivot-data-cleaning-three-options-with-a-football-angle-of-course/
http://powerpivotpro.wordpress.com/2009/10/31/excel-team-blog-great-powerpivot-content/
http://powerpivotpro.wordpress.com/2009/11/01/sp-conf-2009-last-two-observations/
http://powerpivotpro.wordpress.com/2009/11/02/thank-you-mariano/
http://powerpivotpro.wordpress.com/2009/11/02/haunted-by-myself-circa-1996/
http://powerpivotpro.wordpress.com/2009/11/02/sharepoint-samurais-surrational-sharepoint-fairy/
http://powerpivotpro.wordpress.com/2009/11/02/powerpivot-football-project-the-first-dax-formulas-and-relationships/
http://powerpivotpro.wordpress.com/2009/11/03/linkedin-poll-on-excel-bi-usage/
http://powerpivotpro.wordpress.com/2009/11/03/playing-with-theme-again/
http://powerpivotpro.wordpress.com/2009/11/03/relationships-pivots-and-dax-the-payoff-part-one/
http://powerpivotpro.wordpress.com/2009/11/04/hiding-fields-from-the-field-list-in-ctp3/
http://powerpivotpro.wordpress.com/2009/11/04/trusting-the-data/
http://powerpivotpro.wordpress.com/2009/11/05/ohio-area-powerpivot-summit/
http://powerpivotpro.wordpress.com/?p=471
http://powerpivotpro.com/?p=477
http://powerpivotpro.wordpress.com/2009/11/06/comments-links-and-no-question-left-behind/
http://powerpivotpro.wordpress.com/?p=535
http://powerpivotpro.wordpress.com/2009/11/07/powerpivot-better-football-project-links/
http://powerpivotpro.wordpress.com/2009/11/07/powerpivot-beta-ctp3-release-date/
http://powerpivotpro.wordpress.com/2009/11/08/three-new-powerpivot-blogs/
http://powerpivotpro.wordpress.com/2009/11/09/sports-fans-use-bi/
http://powerpivotpro.wordpress.com/2009/11/10/a-48-hour-case-study-from-bing-zero-to-sixty/
http://powerpivotpro.wordpress.com/2009/11/10/darinees-powerpivot-adventure-postscript/
http://powerpivotpro.wordpress.com/2009/11/10/dax-the-related-function/
http://powerpivotpro.wordpress.com/2009/11/10/more-excel-services-api-info/
http://powerpivotpro.wordpress.com/2009/11/12/does-powerpivot-need-office-2010-deployed-everywhere/
http://powerpivotpro.wordpress.com/2009/11/12/now-that-was-bizarre/
http://powerpivotpro.wordpress.com/2009/11/12/ugh/
http://powerpivotpro.wordpress.com/?p=628
http://powerpivotpro.wordpress.com/2009/11/12/excel-blog-dashboard-improvements/
http://powerpivotpro.wordpress.com/2009/11/13/the-temperature-data-from-last-nights-video/
http://powerpivotpro.wordpress.com/?p=640
http://powerpivotpro.wordpress.com/2009/11/17/powerpivot-beta-ctp3-tomorrow/
http://powerpivotpro.wordpress.com/2009/11/18/powerpivot-ctp3-beta-download-links/
http://powerpivotpro.wordpress.com/2009/11/18/temperature-mashup-demo-download-the-workbook/
http://powerpivotpro.wordpress.com/2009/11/19/good-stuff-from-the-geek/
http://powerpivotpro.wordpress.com/2009/11/20/updated-powerpivot-for-sharepoint-install-steps/
http://powerpivotpro.wordpress.com/2009/11/21/the-coming-week/
http://powerpivotpro.wordpress.com/new-to-the-site/
http://powerpivotpro.wordpress.com/2009/11/22/at-last-we-meet-samurai/
http://powerpivotpro.wordpress.com/2009/11/24/fixed-version-of-the-qty-per-day-measure/
http://powerpivotpro.wordpress.com/2009/11/24/thank-you/
http://powerpivotpro.wordpress.com/2009/11/24/kasper-de-jonge-video/
http://powerpivotpro.wordpress.com/2009/11/27/why-bi-spending-defies-recessions/
http://powerpivotpro.wordpress.com/2009/12/01/back-home-tonight-powerpivot-content-resumes/
http://powerpivotpro.wordpress.com/2009/12/01/putting-the-intelligence-in-business-intelligence-part-1/
http://powerpivotpro.wordpress.com/2009/12/04/some-recent-powerpivot-links/
http://powerpivotpro.wordpress.com/2009/12/04/visualizing-sql-indices-with-powerpivot/
http://powerpivotpro.wordpress.com/2009/12/04/putting-the-intelligence-in-business-intelligence-pt-2/
http://powerpivotpro.wordpress.com/2009/12/08/an-oldie-but-a-goodie-the-evil-pivot-wizard/
http://powerpivotpro.wordpress.com/2009/12/08/daxs-calculate-function-pivots-will-never-be-the-same/
http://powerpivotpro.wordpress.com/2009/12/10/putting-the-intelligence-in-business-intelligence-pt-3/
http://powerpivotpro.wordpress.com/?p=767
http://powerpivotpro.wordpress.com/2009/12/14/powerpivot-dax-calculate-is-a-supercharged-sumif/
http://powerpivotpro.wordpress.com/2009/12/15/powerpivot-com-revamped/
http://powerpivotpro.wordpress.com/2009/12/16/dax-calculate-and-rapid-iteration/
http://powerpivotpro.wordpress.com/2009/12/18/the-anti-inspiration-for-powerpivot-ux/
http://powerpivotpro.wordpress.com/?p=833
http://powerpivotpro.wordpress.com/2009/12/29/server-install-cheatsheets-from-powerpivot-geek/
http://powerpivotpro.wordpress.com/?p=868
http://powerpivotpro.wordpress.com/2010/01/04/more-discussion-on-gauges/
http://powerpivotpro.wordpress.com/2010/01/05/give-me-good-data-or-give-me-um-good-data/
http://powerpivotpro.wordpress.com/2010/01/06/cursed-spam-filter/
http://powerpivotpro.wordpress.com/the-faq/
http://powerpivotpro.wordpress.com/2010/01/07/powerpivot-for-science/
http://powerpivotpro.wordpress.com/2010/01/08/touchdown-problem-solved-and-countrows/
http://powerpivotpro.wordpress.com/2010/01/08/the-faq-is-now-accepting-applications/
http://powerpivotpro.wordpress.com/2010/01/10/more-on-visualization/
http://powerpivotpro.wordpress.com/2010/01/11/announcing-our-esteemed-faq-moderators/
http://powerpivotpro.wordpress.com/2010/01/12/podcast-with-ross-mclean/
http://powerpivotpro.wordpress.com/?p=909
http://powerpivotpro.wordpress.com/?p=915
http://powerpivotpro.wordpress.com/2010/01/13/visitors-map/
http://powerpivotpro.wordpress.com/2010/01/14/the-bug-count-also-rises/
http://powerpivotpro.wordpress.com/2010/01/14/mr-excel-joins-faq-moderation-team/
http://powerpivotpro.wordpress.com/?p=963
http://powerpivotpro.wordpress.com/2010/01/25/omg-its-a-naked-donald-farmer/
http://powerpivotpro.wordpress.com/?p=971
http://powerpivotpro.wordpress.com/2010/02/01/parameterizing-the-report/
http://powerpivotpro.wordpress.com/2010/02/02/introducing-cubeset-and-cuberankedmember/
http://powerpivotpro.wordpress.com/2010/02/02/link-to-cube-formulas-spreadsheet-fixed/
http://powerpivotpro.wordpress.com/2010/02/04/pivots-i-have-not-forgotten-ye/
http://powerpivotpro.wordpress.com/2010/02/04/tommy-farmer-donny-chong-a-photo-essay/
http://powerpivotpro.wordpress.com/2010/02/05/powerpivot-data-in-scatter-charts-etc/
http://powerpivotpro.wordpress.com/2010/02/06/espionage-spam-ravings-of-a-lunatic/
http://powerpivotpro.wordpress.com/2010/02/07/captain-ramius-returns/
http://powerpivotpro.wordpress.com/2010/02/08/surprising-example-of-powerpivot-compression/
http://powerpivotpro.wordpress.com/2010/02/09/dirty-swedish-video/
http://powerpivotpro.wordpress.com/2010/02/10/a-few-new-faq-features/
http://powerpivotpro.wordpress.com/2010/02/11/calling-for-guest-posts/
http://powerpivotpro.wordpress.com/?p=1128
http://powerpivotpro.wordpress.com/2010/02/11/quick-data-prep-trick-use-a-flat-pivot/
http://powerpivotpro.wordpress.com/2010/02/12/captain-ramius-epilogue/
http://powerpivotpro.com/?p=1155
http://powerpivotpro.wordpress.com/2010/02/15/sweden-the-full-videos/
http://powerpivotpro.wordpress.com/2010/02/15/dax-ive-been-shortchanging-you/
http://powerpivotpro.wordpress.com/?p=1191
http://powerpivotpro.wordpress.com/2010/02/19/the-superheroes-of-dax-and-derived-measures/
http://powerpivotpro.wordpress.com/?p=1222
http://powerpivotpro.wordpress.com/?p=1254
http://powerpivotpro.wordpress.com/2010/02/25/just-call-me-pivot-mc-pivot/
http://powerpivotpro.wordpress.com/?p=1274
http://powerpivotpro.wordpress.com/2010/03/01/guest-post-dany-hoter-on-cube-formulas/
http://powerpivotpro.wordpress.com/2010/03/02/just-joining-us/
http://powerpivotpro.wordpress.com/2010/03/02/minnesota-in-the-morning/
http://powerpivotpro.wordpress.com/2010/03/04/excel-monkey-uprising-and-a-contest/
http://powerpivotpro.wordpress.com/2010/03/05/do-you-work-for-a-sports-team/
http://powerpivotpro.wordpress.com/2010/03/08/writing-a-rank-measure-and-living-to-tell-the-tale/
http://powerpivotpro.wordpress.com/?p=1295
http://powerpivotpro.wordpress.com/2010/03/11/rank-continued-dealing-with-unknown-members/
http://powerpivotpro.wordpress.com/2010/03/15/the-great-broken-links/
http://powerpivotpro.wordpress.com/2010/03/16/retailer-overlap-analysis-using-powerpivot/
http://powerpivotpro.wordpress.com/2010/03/21/rank-measure-finished/
http://powerpivotpro.wordpress.com/?p=1472
http://powerpivotpro.wordpress.com/2010/03/29/notepad/
http://powerpivotpro.com/?p=1481
http://powerpivotpro.wordpress.com/2010/04/05/notepad-and-dax-guest-post-from-colin-banfield/
http://powerpivotpro.wordpress.com/2010/04/05/dax-xml-file-from-colin/
http://powerpivotpro.wordpress.com/2010/04/07/david-coe-wins-excel-monkey-contest/
http://powerpivotpro.wordpress.com/2010/04/07/quick-tip-dont-over-use-filter/
http://powerpivotpro.com/?p=1540
http://powerpivotpro.wordpress.com/?p=1547
https://powerpivotpro.wordpress.com/2010/04/27/new-docs-from-redmond/
https://powerpivotpro.wordpress.com/2010/05/03/powerpivot-v1-released-to-msdn/
https://powerpivotpro.wordpress.com/2010/05/04/powerpivot-interest-by-industry/
https://powerpivotpro.wordpress.com/2010/05/05/may-12th-in-nyc-it-cant-hide-from-ms-excel/
https://powerpivotpro.wordpress.com/2010/05/06/automating-the-site-visitors-xl-report/
https://powerpivotpro.wordpress.com/2010/05/14/i-thought-this-was-kinda-cool/
https://powerpivotpro.wordpress.com/2010/05/17/i-risk-serious-bodily-injury-vs-the-dutch-menace/
https://powerpivotpro.wordpress.com/2010/05/27/up-for-air-briefly/
https://powerpivotpro.wordpress.com/2010/05/28/pivotstream-has-a-new-logo/
https://powerpivotpro.wordpress.com/?p=1617
https://powerpivotpro.wordpress.com/?p=1622
http://powerpivotpro.com/?p=1609
http://powerpivotpro.com/?p=1640
http://powerpivotpro.com/?p=1645
http://powerpivotpro.com/?p=1656
http://powerpivotpro.com/?p=1654
https://powerpivotpro.wordpress.com/2010/06/11/powerpivot-observations-from-techedbi-conf-pt-1/
https://powerpivotpro.wordpress.com/?p=1679
http://powerpivotpro.com/?p=1693
https://powerpivotpro.wordpress.com/2010/06/17/teched-bi-conference-slides/
http://powerpivotpro.com/?p=1700
https://powerpivotpro.wordpress.com/2010/06/23/quick-tip-disable-addin-for-rapid-layout/
https://powerpivotpro.wordpress.com/2010/06/26/powerpivot-field-list-and-excel-field-list-at-same-time/
https://powerpivotpro.wordpress.com/2010/07/02/slicers-and-pivot-update-performance/
http://powerpivotpro.com/?p=1756
https://powerpivotpro.wordpress.com/?p=1765
https://powerpivotpro.wordpress.com/2010/07/26/two-excellent-powerpivot-books/
https://powerpivotpro.wordpress.com/2010/07/27/win-an-msdn-subscription-free-software/
https://powerpivotpro.wordpress.com/2010/07/28/wheres-waldo-contest-two-hints/
https://powerpivotpro.wordpress.com/2010/07/31/the-most-tenacious-man-in-the-world/
https://powerpivotpro.wordpress.com/?page_id=1804
http://powerpivotpro.com/?p=1840
https://powerpivotpro.wordpress.com/2010/08/14/two-common-powerpivot-error-messages/
https://powerpivotpro.wordpress.com/2010/08/16/pivot-refresh-vs-update-is-there-a-real-difference/
https://powerpivotpro.wordpress.com/2010/08/19/review-prof-powerpivot-for-excel-sharepoint/
https://powerpivotpro.wordpress.com/?p=1829
http://powerpivotpro.com/?p=1883
https://powerpivotpro.wordpress.com/2010/08/23/powerpivot-vba-macro-mania/
https://powerpivotpro.wordpress.com/2010/08/30/a-few-tips-on-maintainability/
https://powerpivotpro.wordpress.com/?p=1922
https://powerpivotpro.wordpress.com/2010/09/06/1300-measures-nightmare-or-utopia/
http://powerpivotpro.com/?p=1951
https://powerpivotpro.wordpress.com/2010/09/15/interview-with-jamiemac-of-predixion-software/
https://powerpivotpro.wordpress.com/2010/09/20/contest-many-charts-shared-slicers-fast-queries/
https://powerpivotpro.wordpress.com/2010/09/22/contest-update/
https://powerpivotpro.wordpress.com/2010/09/23/customized-sharepoint-report-portal/
https://powerpivotpro.wordpress.com/2010/10/01/top-5-ways-powerpivot-helps-excel-pros/
https://powerpivotpro.wordpress.com/2010/10/04/illustrated-guide-to-excel-services-chart-rendering/
http://powerpivotpro.com/?p=1989
https://powerpivotpro.wordpress.com/2010/10/11/added-a-search-box/
https://powerpivotpro.wordpress.com/2010/10/12/more-powerpivot-consulting-observations/
https://powerpivotpro.wordpress.com/?p=2008
https://powerpivotpro.wordpress.com/?p=2018
https://powerpivotpro.wordpress.com/2010/11/01/add-a-last-refreshed-date-readout/
https://powerpivotpro.wordpress.com/2010/11/05/going-to-pass-track-me-down/
https://powerpivotpro.wordpress.com/2010/11/05/psst-sports-league-yeah-you/
https://powerpivotpro.wordpress.com/2010/11/07/ok-powerpivot-green-after-all/
https://powerpivotpro.wordpress.com/2010/11/12/five-observations-from-sql-pass/
https://powerpivotpro.wordpress.com/2010/11/16/learning-dax-measures-the-spicy-function-scale/
https://powerpivotpro.wordpress.com/2010/11/22/time-to-rename-traditional-bi/
https://powerpivotpro.wordpress.com/2010/11/25/thanksgiving-thought-a-bi-pro-reflects-on-investing/
https://powerpivotpro.wordpress.com/2010/11/30/hardwarecapacity-planning-from-the-trenches/
https://powerpivotpro.wordpress.com/2010/12/02/powerpivot-for-excel-2007/
https://powerpivotpro.wordpress.com/2010/12/06/powerpivot-refresh-cpuram-spike-at-completion/
https://powerpivotpro.wordpress.com/2010/12/09/another-way-to-get-and-use-slicer-values-in-formulas/
https://powerpivotpro.wordpress.com/2010/12/23/santas-elven-productivity-simulator-leaked-online/
https://powerpivotpro.wordpress.com/2011/01/03/powerpivot-scheduled-refresh-twists-turns-pt-1/
https://powerpivotpro.wordpress.com/2011/01/04/speaking-at-sql-saturday-60-cleveland/
https://powerpivotpro.wordpress.com/2011/01/06/donald-farmer-leaves-ms-for-qliktech/
https://powerpivotpro.wordpress.com/2011/01/09/the-tommy-chong-meme-spreads/
http://powerpivotpro.com/?p=2132
https://powerpivotpro.wordpress.com/2011/01/12/data-refresh-twiststurns-pt2-pivot-refresh/
https://powerpivotpro.wordpress.com/?p=2180
https://powerpivotpro.wordpress.com/2011/01/23/got-a-high-end-cpu-please-help-w-an-experiment/
https://powerpivotpro.wordpress.com/2011/01/25/live-in-europe-powerpivot-workshop/
https://powerpivotpro.wordpress.com/?p=2223
https://powerpivotpro.wordpress.com/?p=2237
https://powerpivotpro.wordpress.com/2011/02/07/is-the-future-of-office-too-tightly-tied-to-sharepoint/
https://powerpivotpro.wordpress.com/2011/02/07/beta-program-update/
https://powerpivotpro.wordpress.com/2011/02/10/speaking-at-columbus-oh-user-group-tonight/
https://powerpivotpro.wordpress.com/2011/02/19/james-bond-international-biz-intel-operative/
https://powerpivotpro.wordpress.com/?p=2277
https://powerpivotpro.wordpress.com/2011/03/02/buying-a-powerpivot-server-talk-to-me-first/
https://powerpivotpro.wordpress.com/2011/03/09/the-magic-of-ifvalues/
https://powerpivotpro.wordpress.com/?p=2307
https://powerpivotpro.wordpress.com/2011/03/16/guest-post-catalog-your-measure-with-a-nifty-macro/
https://powerpivotpro.wordpress.com/2011/03/23/are-you-making-daiquiris-or-blenders/
http://powerpivotpro.com/?p=2341
https://powerpivotpro.wordpress.com/2011/03/28/announcing-the-great-powerpivot-survey/
https://powerpivotpro.wordpress.com/2011/03/31/guest-post-nth-occurrence-dax-formula/
https://powerpivotpro.wordpress.com/2011/04/01/the-great-powerpivot-survey-results-preview/
https://powerpivotpro.wordpress.com/2011/04/05/survey-results-part-2-tech-pros-vs-excel-pros/
https://powerpivotpro.wordpress.com/2011/04/13/ab-campaign-analysis-with-start-end-date-slicers/
https://powerpivotpro.wordpress.com/2011/04/22/calculating-a-sum-based-on-a-list-criteria/
https://powerpivotpro.wordpress.com/2011/04/22/the-friendly-neighborhood-operators-and/
https://powerpivotpro.wordpress.com/2011/05/05/portable-formulas-an-underestimated-benefit/
https://powerpivotpro.wordpress.com/?p=2456
https://powerpivotpro.wordpress.com/?p=2469
https://powerpivotpro.wordpress.com/2011/05/27/three-quick-news-updates/
https://powerpivotpro.wordpress.com/?p=2487
https://powerpivotpro.wordpress.com/2011/06/10/two-tips-from-the-old-country/
https://powerpivotpro.wordpress.com/2011/06/14/the-great-precedence-project-filter-rules-for-dax/
https://powerpivotpro.wordpress.com/2011/06/16/precedence-project-part-two-values/
https://powerpivotpro.wordpress.com/powerpivot-hosting/
https://powerpivotpro.wordpress.com/2011/06/22/precedence-part-3-allexcept-vs-all-w-values/
https://powerpivotpro.wordpress.com/2011/06/24/homer-simpson-has-more-accurate-computing-than-us/
https://powerpivotpro.wordpress.com/2011/06/30/running-totals-without-a-traditional-calendar-table/
https://powerpivotpro.wordpress.com/2011/07/12/powerpivot-v2-ctp3/
https://powerpivotpro.wordpress.com/2011/07/20/guest-post-topn-in-powerpivot-v2/
https://powerpivotpro.wordpress.com/2011/07/20/couldnt-resist-parameterized-powerpivot-report/
https://powerpivotpro.wordpress.com/2011/07/28/distinct-count-in-powerpivot-v2-much-faster/
https://powerpivotpro.wordpress.com/2011/07/29/what-color-are-santa-clauss-pants/
https://powerpivotpro.wordpress.com/2011/08/01/less-columns-more-rows-more-speed/
https://powerpivotpro.wordpress.com/2011/08/03/value-proposition-of-powerpivot-in-cima-insight/
https://powerpivotpro.wordpress.com/2011/08/17/sharepoint-saturday-columbus-this-weekend/
https://powerpivotpro.wordpress.com/2011/08/18/rackspace-webinar-from-june/
http://www.powerpivotpro.com/?p=2668
http://www.powerpivotpro.com/?p=2669
http://www.powerpivotpro.com/?p=2670
http://www.powerpivotpro.com/?p=2671
http://www.powerpivotpro.com/?p=2672
http://www.powerpivotpro.com/?p=2673
http://www.powerpivotpro.com/?p=2674
http://www.powerpivotpro.com/2011/08/new-server/
http://www.powerpivotpro.com/2011/09/guest-post-greater-thanless-thanbetween-slicers/
http://www.powerpivotpro.com/2011/09/powerpivot-refresh-thru-vba-at-last/
http://www.powerpivotpro.com/2011/09/tuesdaythursday-post-schedule-an-experiment/
http://www.powerpivotpro.com/?p=2685
http://www.powerpivotpro.com/2011/09/blog-outage/
http://www.powerpivotpro.com/?p=2712
http://www.powerpivotpro.com/2011/09/cima-insight-pt-2-the-hidden-costs-of-traditional-bi/
http://www.powerpivotpro.com/?p=2779
http://www.powerpivotpro.com/?p=2814
http://www.powerpivotpro.com/2011/09/sql-saturday-85-orlando-fl-september-24/
http://www.powerpivotpro.com/?p=2715
http://www.powerpivotpro.com/2011/09/mr-excel-makes-his-hostedpowerpivot-site-public/
http://www.powerpivotpro.com/?p=2701
http://www.powerpivotpro.com/2011/09/slides-from-sql-sat-85/
http://www.powerpivotpro.com/?p=2887
http://www.powerpivotpro.com/?p=2897
http://www.powerpivotpro.com/?p=2913
http://www.powerpivotpro.com/2011/10/powerpivot-roi-comparison-cima-part-three/
http://www.powerpivotpro.com/2011/10/friday-bonus-ufo-sightings-hallucinogen-use/
http://www.powerpivotpro.com/?p=2926
http://www.powerpivotpro.com/2011/10/user-friendly-report-sorting-with-slicers/
http://www.powerpivotpro.com/?p=3058
http://www.powerpivotpro.com/?p=2992
http://www.powerpivotpro.com/2011/10/try-out-sort-by-slicers-ufos-in-browser-no-login/
http://www.powerpivotpro.com/?p=3076
http://www.powerpivotpro.com/2011/10/sharepoint-saturday-cincy/
http://www.powerpivotpro.com/2011/10/off-topic-halloween-humor/
http://www.powerpivotpro.com/2011/11/what-if-spreadsheets-were-invented-today/
http://www.powerpivotpro.com/2011/11/mini-post-1-of-4-powerpivot-pro-needed-in-denmark/
http://www.powerpivotpro.com/2011/11/mini-post-24-sql-saturday-tampa-this-wknd/
http://www.powerpivotpro.com/?p=2960
http://www.powerpivotpro.com/2011/11/mini-post-44-refreshing-the-faq-recruiting-new-contributors/
http://www.powerpivotpro.com/?p=3117
http://www.powerpivotpro.com/?p=3163
http://www.powerpivotpro.com/2011/11/the-ultimate-date-table/
http://www.powerpivotpro.com/2011/11/comparing-access-to-powerpivot/
http://www.powerpivotpro.com/2011/11/why-powerpivot-is-better-fed-from-a-database-pt-1/
http://www.powerpivotpro.com/2011/11/delayed-today-but-post-still-coming/
http://www.powerpivotpro.com/2011/11/why-powerpivot-is-better-fed-from-a-database-pt2/
http://www.powerpivotpro.com/?p=3218
http://www.powerpivotpro.com/?p=3224
http://www.powerpivotpro.com/2011/12/friday-bonus-excel-goes-gangsta/
http://www.powerpivotpro.com/?p=3271
http://www.powerpivotpro.com/?p=3288
http://www.powerpivotpro.com/2011/12/friday-bonus-gang-sign-photos-so-far/
http://www.powerpivotpro.com/2011/12/the-greatest-formula-in-the-world-part-3/
http://www.powerpivotpro.com/?p=3343
http://www.powerpivotpro.com/?p=3448
http://www.powerpivotpro.com/?p=3465
http://www.powerpivotpro.com/?p=3409
http://www.powerpivotpro.com/?p=3491
http://www.powerpivotpro.com/?p=3503
http://www.powerpivotpro.com/?p=3509
http://www.powerpivotpro.com/?p=3620
http://www.powerpivotpro.com/?p=3647
http://www.powerpivotpro.com/?p=3532
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########

								
To top