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.
Content Type: Blog Post
The High Cost of Poor Equipment
Over the last 12 months I have engaged with may people from lots of different companies on the topic of Power Pivot.
Giving Back: “Steal” this Reference Card!
A long time coming… The Finalized 8-Page “Reference Card V2” – Download it for Free Below Yes, this took me forever. I first posted about it more than
Interview with Kamal Hathi of Microsoft, plus “AMA!”
Director of Product Management, Microsoft BI
Share and Refresh Power Query & PBI Get Data with Local Links
The concept of parameter tables in Power Query will be familiar to some and new to others. A parameter table is a way that you can “pass” values to Power Query (and also Power Pivot) and these values can then be used in your queries and/or the data model.
Complex Customer Cohort Retention Using PRODUCTX
Post by Rob Collie First, a Few Quick Updates…
Power Query as an SSIS Alternative
One of the many things I love about Power Pivot and Power Query is that these tools have put BI into the hands of users
Two Tricks to Make Your Cube Formula Scorecards Drama-Free!
Guest Post by Andrew Todd Cube Formulas: Ultimate flexibility for your reports but lots of drama to update… A while back, I was tasked with finding a way to automate […]
Power BI Desktop New Feature: Bi-Directional Relationships!
An article on the Power BI Desktop New Feature by the experts at P3 Adaptive .
Free Webinar: Excel to Power BI, Tue Aug 18
We’ll be hosting our monthly “Excel to Power BI” Webinar on Aug 18. Short notice, I know. But that means you have no excuse to dally, register today! Invite your colleagues, friends, even your mum.
Transitioning from Excel Power Pivot/Query to Power BI Desktop: A Remarkably Smooth Road
An article on how to transition from Excel Power Pivot or Power Query to Power BI Desktop from the experts at P3 Adaptive .
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.