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
Search Results for: https://ww
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.
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 .
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.
Cycle Plots Show You Data Insights using Power Pivot and Power BI
By Avi Singh [Twitter] If you want to look for trends based on weekday (Sunday…Saturday) or month-of-the-year seasonality (January…December), Cycle Plots can be a potent visualization tool.
Power BI Jun 2nd Webinar Recording Available
Thanks to all, who attended our Power BI Webinar on Jun 2nd. We had 400+ (well, 438 to be precise) attend, what ended up being a 2 hour webinar with all the questions being asked.
Red Nose Special: 24 Distinctive Ways to Die
An article on the 24 Distinctive Ways to Die by state.
Power Query Super Charges the Internet
I spent time recently thinking about how Power Query has really opened up the data on the Internet and made it more accessible to us all.
Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine
Intro from Rob: Today I’m interviewing Chris Finlan of Microsoft about MS’s recent acquisition of Datazen, and what this means to us in the Power Pivot and Power BI community.
Harness Power Query to Gain Competitive Analysis Insights from LinkedIn
Guest Post by Gil Raviv Intro: Many experts had proclaimed LongForm Journalism was headed towards extinction in the digital age. In fact it has found a new resurgence and a […]