Navigating the sea of data One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For example, receivables not being paid…

Many accountants consider that cash flow statements are the most important indicator of a company’s performance, as they do not involve estimates or judgments of the preparers. While indirect method cash flow statements can be prepared easily from P&L…

A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries. Each subsidiary can also have one or multiple subsidiaries beneath it.…

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? Why Test? Quality testing is one of those things that few of us enjoy but is…

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. When…

Recently I was teaching a private course on Power BI to one of our clients. We were learning about the ALL() function and how to use it to get % of total calculations. After demonstrating how to get an individual…

I read this blog (and Matt Allington, and Ken Puls) pretty religiously. But PowerPivotPro is probably my favorite because it deals with a lot of real-world situations, not just technical solutions. So, I’m going to continue that theme and…

In Part I, we used the query editor and the M List functions to generate all the possible combinations of five and seven cards from a standard deck. To score all the possible combinations of seven cards (133M possible hands…

Last month I saw a puzzle posted on fivethirtyeight.com about poker hand probabilities and, like with many things these days, wondered how I could solve it with PowerBI. I had been curious to learn more about the M list functions,…

Intro How did I come to PowerPivot and the related tools? Desperation in trying to fix a process problem. How did I get to the point where I can return a reasonable answer to a data query using the Power…