Cube Functions, the good the bad and how to make them great
I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent:
Category: Beginner
Automated Testing Using Dax for Power BI
How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right?
Using Dax to create a KPI
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper.
Dax: Back to the basics
For me, whenever I am new to a concept, and I read a statement like the one above, I often say “Well that’s great, but just what does that mean?” I am a big believer in mental models or ways of visualizing the flow of execution.
Power Query (M)agic – Nested Calculations in Power Query – Finance Application
One of the most powerful features (and there are lots) that I’ve found about Power Query is the ability to hold an entire table in a single cell.
PowerQuery (M)agic: Combine M Functions and Formulas In Custom Columns
Humans like turning a few things into many things. Investing $1 to get $10 . . . growing saplings into oaks . . . taking two rabbits and creating a fluffle.
Navigating DAX Function Types: A list of DAX Scalar and Table functions
Let’s start off today’s post with a pop quiz. Once you’ve answered, click here to see the poll results, and then scroll down to see the correct answer
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…
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
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.
- 1
- 2