Nested SUMX or DAX Query?
I was helping a friend out recently with an interesting problem. It all started with a SUM( ) that wasn’t behaving.
Search Results for: best pract
Consolidated Worksheets with Power Query
The more I use Power Query, the more I want to use Power Query – and of course the more I learn.
The “Ferrari” of PowerPivot Books
UPDATE: My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.
Interview with JamieMac of Predixion Software
Me: “Can you PLEASE stop answering the question before I even ask it? It’s kinda freaking me out.” Jamie: “I knew you were going to say that.” It is a […]