Power Query (M)agic Part 2: Organizing Your Queries
Learn how to use Power Query like a pro and organize your queries by using this very simple technique. Take your queries and organize them in folders.
Content Type: Blog Post
Stick a Drop Pin in It: Visualize Data With Maps (DAX Reanimator Series: Part 2)
Greetings P3 Adaptive Nation! I’m here today to talk about maps, maps, globes, charts, topographical representations, and…well frankly I’m out of map synonyms. However there’s at least twice as many […]
Why Excel’s Power Query Refresh Speeds Suck
Ever noticed that Power Query refresh is slower in Excel than Power BI? Ken Puls, PQ Expert, explains the problem and what you can do to fix it!
The #1 Missing Feature in Power BI is a Small Thing
I’m going to keep today’s post short and sweet. The #1 missing feature in Power BI is overwhelmingly clear to me, #2 isn’t close, and addressing this should be quite simple for my friends and former colleagues at Microsoft.
Podcast with John Michaloudis!
Awhile back I recorded a podcast with John Michaloudis from MyExcelOnline and it went live today. Fun chat, lots of excitement.
My Top 5 Power BI Visual Design Practices: Transforming Good to GREAT
I’d like to drop some reporting knowledge. I’m going to share some of my best practices for Power BI Reporting I’ve developed over the years
Announcing P3 Adaptive Seattle/Northwest with Power BI!
Hardcore “trying on” the Power BI label. Today, even our national practice is doing about a 50/50 mix of Power Pivot vs. Power BI work.
DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers
Dynamic TopN Reports via Slicers: Now you can click, slice, interact, touch (…dirty), and drill (dirtier!) with these reports to your hearts desire.
Individual Excellence vs. Organizational Impact: Know the Difference!
What We Can Do With “Just” DAX and Modeling. It’s my experience-powered belief that you cannot get a Win of that size without leveraging DAX and Modeling.
M/Power Query “Sets Up” DAX, so Learn DAX (and Modeling) First
You should advance to Intermediate in DAX before advancing to Intermediate in Power Query / M, and then to Mastery of DAX before Mastery of M.
Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
First off…my first post! Being one of the newest (and youngest) members of the P3 Adaptive family has been very exciting so far. As a way of introducing myself, I’d like to share a creative solution to a problem I’m sure many of you have encountered when building a report or dashboard.
Rediscovering (fire)matting: a truly amazing BI “tool”
This automatic BI tool has saved me innumerable hours each month and I find this useful for at least 80% of my DAX formulas.