The Great Function Project – Part 3
Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project.
Content Type: Blog Post
Power Query (M)agic: Super SubVars
The Challenge. I love the idea behind Power Query (M)agic. These posts let Power Query users learn and share best practices (tips & tricks) that solve real problems. Query management comes up a lot.
Journey to P3 Adaptive : Ryan Bergstrom
Sometimes I forget that it has only been a year at P3 Adaptive . Every new client that I have seems like I‘ve spent months getting to know a business, their projects, and the incredible people that move the needle at an organization.
Power BI Feature Spotlight: Using Bookmark Buttons to Create Pop-Up Windows
Hello P3 Adaptive Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe.
The Great Function Project – Part 2
As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting, I could not stop using external workbook links
Agile BI Moves from “If” to “How”
Eight years ago, I lucked into an epiphany: IT-driven BI was going to give way to biz-driven BI (aka “self-service” or “Agile” BI). The new wave of BI tools – led by Power Pivot at the time, which ultimately grew into Power BI – gave business subject matter experts something they’d previously lacked: the ability to execute directly.
Using DAX Magic For Variable Forecasting
I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection.
March Madness in Power BI
It’s time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI.
PBI Spotlight: NEW & IMPROVED Tooltips
Hello again P3 Adaptive Nation! I’m SUPER excited today to talk about an updated feature in Power BI Desktop.
The Great Function Project – Part 1
P3 Adaptive has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in terms of success.
How to Get Power BI Service to Work for You
I’ve been using the Power BI Service (PBIS) daily for five months, and before that, I consulted on challenging DAX problems for over a year.
Power Query (M)agic: Dynamically remove leading rows AND columns
The scenario – source data sheets that are structured differently! Does Power Query sometimes seem too rigid? It’s great for defining a sequence of transformations to clean your data but […]