Advanced

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

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,…

Background Think back to the year 2012 when Microsoft introduced us to SQL Server Analysis Services Tabular models. It was new and exciting. The Excel gurus who had been using PowerPivot since 2010 were sneering at us like we were…

A few years ago, on February 14th, 2013, I fell head over heels onto a rocket ship that kicks just as much, well it kicks more ass than Tyler Durden on his best day. Valentine’s Day coincidence? Maybe I’ll get…

Your First Co-Development Project P3 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…

Surfs Up 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.” This means that I have a host of personal…

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. Synced slicers have arrived! Now you can apply a user’s selected filter criteria throughout the…

Welcome to the latest PowerPivotPro Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on a Slack channel, and are then lightly…

Every month Power BI gets an update that adds a nice handful of new features. Here at P3 we ALL get excited for this! We often stand around the water cooler talking about all the new features. When a REALLY…