Guest Post: Catalog Your Measures with a Nifty Macro
UPDATE: Uploaded a new version of the macro file that David provided that fixed a couple of small problems. Also, I fixed a typo (I had it as XSLM, not […]
Category: Quick Tips & Tricks
DAX – More Fun With IF(VALUES())
“I mean, IF() I’m paying top dollar, I want a little production VALUE()” I bet you thought I was out of movie quotes for IF(VALUES()) didn’t you! If I had […]
DAX – The Magic of IF(VALUES())
“I’m Dan Marino, and IF() anyone knows the VALUE() of protection, it’s me.” Boom! An Ace Ventura quote finally graces the blog. Yes folks, that fine work of American cinema […]
Date and Date/Time – Sneaky Data Types!
These Two Columns Both Contain Dates, Right? Sure They Do! Relationships that should work, but aren’t? Here’s a quick tip, one that I think we’ll all need sooner or later. […]
Illustrated guide to Excel Services Chart Rendering
COMMON QUESTION: “Hey, will this chart render unchanged in Excel Services, or will it look different?” MY STOCK ANSWER: “Hmm, I forget, let’s try it out” I hate giving that […]
A few tips on maintainability
Eat This Not That, PowerPivot Edition! Just like normal Excel, PowerPivot requires little or no premeditation – you can just jump right in and build something quite impressive. But if […]
Two common PowerPivot error messages
Been meaning to post this for awhile now. Here are two error messages I see all the time now, about once per day: UPDATED: I’ve found a third message that […]
Calling a Stored procedure in PowerPivot
By Kasper de Jonge, crosspost from PowerPivotblog.nl While building a new PowerPivot workbook i wanted to use Time Intelligent functions. One of the golden rules of PowerPivot time intelligent functions is […]
The Superheroes of DAX, and derived measures
“Did someone say DAX?” I wanted to start today’s post with a quick thank-you to the guys who tirelessly answer my DAX questions. Marius Dumitru, Howie Dickerman, and Karen Aleksanyan. […]
Quick Data Prep Trick: Use a Flat Pivot!
Today I had a huge source table that looked like this: Store Month Payment Type Some Number A Jan Cash 10 A Jan Credit 12 A Jan Debit 13 A […]
PowerPivot Data in Scatter Charts, etc.
This was going around on the MS-internal discussion list this past weekend: At right is a list of all chart types in Excel. But not all of them are supported […]