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 .
Content Type: Blog Post
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.
DAX – RANKX with Ascending Order to Show Lowest Quotes by Vendors
This post is based on a query that I got in our monthly Q&A session held for our Online Class attendees.
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.
Power BI Designer vs. Excel: What’s Microsoft Up To?
This is Power BI Designer, a New Product from Microsoft, and It’s Relevant to ALL of Us.
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.
RANKX-apalooza: Within and Across Groups, With Filters, Etc.
One from the Reference Stacks I sometimes find RANKX() a bit perplexing. So awhile back I made myself a workbook of
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.
A New Take on “Data Quality?”
Bad Data DOES Lead to Bad Results. But Good Data Can STILL Lead to Bad Results. Garbage in, Garbage out. We’re all familiar with this. If you’re being given junky source data, it’s going to be hard to perform ANY meaningful analysis or reporting on said data until the quality of the inputs is addressed.
Some Good Power Pivot / Power BI Computers
Last month I posted a survey of computer performance for Power Pivot and Power BI usage.