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.
Category: Page Type
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
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.
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…
Mini Post #2: Mr. XL Launches PowerPivot Forum
The other day I suggested to Bill Jelen that he might want to add a PowerPivot-dedicated forum on MrExcel.com. I wasn’t sure what he would say, to be honest.
Data of Different Grains Using DAX: A Followup
Quick Recap: We Created a Separate “Periods” Table In last week’s post, I explained how PowerPivot can very easily help you solve the “Budget vs. Actuals” problem or any other problem where you have data sets
Sales/Budget: Integrating Data of Different “Grains”
Some of you know that I’ve been writing a series of articles for the Chartered Institute of Management Accounts, aka CIMA
In the Browser, Aesthetics Yield a Greater Return
I thought today was going to be a “handful of mini posts” kind of day but then this post blossomed into a bit more than I thought it would, which is a good thing.
DAX – Switching Subtotals On & Off Dynamically Using DAX in PowerPivot
In this post, I’ll explain how to create a dynamic measure that works out whether a subtotal is needed and displays that subtotal accordingly. I’ll be using the report that was created as part of the Cash Flow Statement post.