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
Category: Power BI
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.
So Your Detailed/Flat Pivot is Slow and Doesn’t Sort Properly? Try Text Measures!
Yes, you know that pivots are meant to show aggregations. Summaries.
Power BI Desktop (Designer) vs. Excel: Rematch
In our last webinar the #1 question and confusion seemed to be around Excel versus Power BI Desktop (formerly called Power BI Designer). The thing is, both tools are really part of an ecosystem. And the biggest confusion was around understanding how these tools fit into the overall landscape.