The Ten Pitfalls of the Data Wrangler (aka the Wielder of M/Power Query)
Ten Pitfalls of the wrangling of using Power Query and how to avoid them, written by P3 Adaptive , Rob Collie.
Search Results for: best practice
Break your DAX Problem into Manageable Parts
One of the concepts I discuss in my new book Learn to Write DAX, is that you should break your DAX problems into manageable pieces so that you can solve the problem one step at a time.
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.
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 […]