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 […]
Content Type: Blog Post
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.
DAX – Correlating “Fuzzy Time” Events in One Table with Precise Measurements in Another Table
The Streak is Broken… and a new streak begins. Well it was a full six-month run of posting every Tuesday and Thursday, Cal Ripken-like consistency. Then last week it ended.
My Experiences with Hosted PowerPivot, Part One
Almost exactly six months ago, after being a long time reader of this blog, I emailed Rob and asked him a question regarding something that I just couldn’t get my head around in DAX – Banding!
Converting from Peaks to Frequencies Using DAX
Folks I just can’t resist a quick followup on the Rat Sniffing Project. I… just… can’t. Plus I am absolutely worn down and don’t have the energy tonight for anything that isn’t inherently entertaining.
Peak Detection: A Surprising Usage of DAX
In a recent post I covered a very simple scientific scenario. It was an interesting diversion from the normal biz-style scenarios but it left me feeling hollow in two ways.
More Live PowerPivot Web Apps!
I’ve got another article about to go live on CIMA Insight, but I’m gonna jump the gun a bit and post basically the entire thing here ahead of time.
Lookups based on date ranges
Another one from the Mr. XL Forum!
…and the word “forum” gives me an excuse for a blast from the past…
Downgrading From PowerPivot v2 to v1
OK, let’s say you already installed v2, whether inadvertently or… advertently. And now you need to downgrade to v1, so that your workbooks function on your server