Using Dax To Handle Multiple Parent Hierarchies
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.
Category: Power Pivot
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.
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.
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 TopN Reports via Slicers, Part 4 – The Dot Plot PivotChart
After completing the Part 3 extension of Rob’s Dynamic TopN Reports via Slicers, Part 2 post, I did not plan on a forth installment.
Dynamic TopN Reports via Slicers, Part 3
After Rob posted Dynamic TopN Reports Using PowerPivot2!, I downloaded the workbook from the provided link to examine how his “tricks” were done
Dynamic TopN Reports via Slicers, Part 2
OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique. Slicer tables […]
DAX – Making the “Case” for SWITCH()
Way back during the period of the first CTP of Gemini (which later became PowerPivot), I was working with a data set that included a column of month numbers
KPI’s in PowerPivot V2
On Tuesday, in my intro to David Hager’s post, I promised to circle back “later today” and add some follow-on thoughts. Well, ONE of those words ended up being truthful
Conditional Formatting with Different Thresholds per Test, per Product, per Store, per Division, etc.
After a long hiatus, David Hager has returned with a new guest post. He has a clever Excel trick/formula for applying different conditional formatting “acceptable ranges” depending on the context of the current row. In his work, different Tests have different acceptable ranges of values that qualify as Pass/Fail/Warning
Percentile Measures in DAX – Errata
Guest Post by Colin Banfield [LinkedIn] In September of last year, I posted two articles on creating percentile measures in DAX. See Creating Accurate Percentile Measures in DAX – Part I and Creating Accurate Percentile Measures in DAX – Part II.
Workarounds for “Canceled Due to Memory Pressure”
You can run into this error via a number of different routes, but one way or another, your computer ran out of memory while PowerPivot was trying to do something.
- 1
- 2