PowerQuery(M)agic: Advance Folder Combine
What an amazing year 2018 has started out to be! Joining the P3 Adaptive team was an aspiration of mine that started in the Fall of 2013…
Category: Intermediate
How to Create A Real Time Dataset on Power BI.com
How to Create A Real Time Dataset on Power BI.com
The Great Function Project – Part 3
Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project.
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
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.
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.
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 […]
Power BI used for Surfing FUN!
A long time ago a peer in Financial Planning and Analysis said “Financial Planning starts in the home.” I modified the statement to “Data analytics starts in the home.”
How to Connect One Slicer to All Your Power BI Report Pages
And another one bites the dust… this month the Power BI team have only delivered the #1 most requested feature on the Power BI Ideas forum.
Power Query (M)agic: Right-Click Your Way To Data Cleaning Happiness
As a ‘water cooler’ of sorts for this community, we meet some amazing people. Doug Burke shares with us how easy Power Query makes it to do powerful cleaning with a click of the mouse.
Using SELECTEDVALUES To Capture Power BI Slicer Selections
Hello P3 Adaptive Nation, I’m excited to be back and writing a technical post again…it’s been too LONG!