Cloud PowerPivot: Free Trials for the Public
UPDATE: I am no longer working at Pivotstream and do not endorse their services. All links are removed from this article but feel free to look them up if you are interested.
Workarounds for “Canceled Due to Memory Pressure”
You can run into this error via a number of different routes, but one way or another, your computer ran out of memory while PowerPivot was trying to do something.
Datamarket: Quick Followup
“There are people out there whose jobs force them to be the place where two sources of data meet, and they are the ones who integrate and cross-reference that data […]
Aged Debtors–Dynamic Banding in DAX
Guest post by David Churchward [Twitter] Having hit the P&L and Cash Flow in previous posts, it seems only reasonable to move on to Balance Sheet aspects. The die-hard “non-accountant” Excel […]
DataMarket Revisited: The Truth is Out There
Yeah, I love quoting movies. And tv shows. And song lyrics. But it’s not the quoting that I enjoy – it’s the connection.
VLOOKUP Week: Who Needs VLOOKUP Anymore?
A couple of years ago at lunch, Bill remarked to me that VLOOKUP was the “scariest” feature in Excel
Poll Results
Even though it is still open, the one-question poll results have stabilized. In fact, the percentages were pretty stable even from the beginning.
The 3rd Most Common Button in Data Apps is…
A little bit of food for thought today, delivered in a pictorial/humorous style but with a serious point. A Running Joke That Never Gets Old I’m quite fond of the […]
Moore’s Law and Inflation
SQL Rockstar, aka Tom LaRock (Blog | Twitter) sent me a fascinating data set the other day: a table of different computing devices over the years, their “horsepower” in calculations per second
DAX – The Correct Usage of EARLIER()
Tonight I was looking at one of my recent posts, the one about “fuzzy” time relationships in calculated columns, and I discovered that I had used the EARLIER() function in places that I did not need to.
Auto-Modify Every Pivot in a Workbook
It’s been awhile since I’ve talked about Macros (also known as VBA). I think it’s overdue. Macros are nothing short of amazing. We couldn’t live without them at Pivotstream
DAX – Subtotals and Grand Totals That Add Up “Correctly”
Busy week here at the MVP Summit in Redmond. As usual, I can’t tell you anything I have learned this week – it’s strictly under NDA.
