The Great Function Project – Part 3
Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project.
Category: DAX
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.
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!
Months and Trailing Twelve Months in One Table
Trailing twelve months (TTM) Power BI. Show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance in one table.
A Star (Schema) and a SWITCH for Drill-Down Income Statement Design
When I was first introduced to PowerPivot five or six years ago, I knew it would serve me well in my FP&A function.
Coffee Talk: DAX Pros
n today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment.
Dynamic Attributes In A Power BI Report
Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.
SUMMARIZE() & ADDCOLUMNS() aren’t scary… if you can SEE them!
I tried solving this problem and the internet led me to SUMMARIZE(). It was stuffed inside another function and it confused me
On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.
One of my colleagues and I have been geeking out the last few years over all things Power (Query, Pivot, View, and now BI).