P3 Adaptive University Open on Chandoo.org
P3 Adaptive University is the same thing as Chandoo’s Advanced Power Pivot. It’s the exact same content, produced and taught by me, under two different names.
Category: Power BI
Two Quick Updates: University Re-Launches Monday. And Power Query is Amazing. AMAZING.
What can I say folks. The Power Pivot “biz” continues to gain steam (one indicator: last week recorded the highest traffic ever to this site) and that means busy days here at P3 Adaptive HQ.
Grand Total Mania! (Totals at Top & Multiple Totals)
Let’s start 2014 with a bang… I’ve been dying to write this post for awhile now. Let’s say you want your grand totals to appear at the top of your […]
A Simple Measure for Projections with Act! CRM
Continuing the series of guest posts that got temporarily shelved, today we have one from Vivek Gargav.
PowerPivot vs. Power View: What’s the Difference?
’ve been getting this question a lot lately: How does Power View relate to PowerPivot? Is PV a replacement for PP?
DAX – HASONEVALUE vs. ISFILTERED vs. HASONEFILTER
Picking up from Tuesday’s post, which drew some quick comments, let’s add one more function to our evaluation: HASONEFILTER().
Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros
Excel 2013 public preview (aka beta) is out, which means that now we’re not only playing around with PowerPivot V2 and Power View V1, but now we have another new set of toys to take for a spin.
Tiered Commissions, Income Taxes, and other “Tiered Rate” Calculations Using DAX
Guest post by David Churchward [Twitter] I mentioned in my LAST POST that I would return with a variation on that commission calculation. Two months later and very much overdue, […]
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.
A Brief Note on PowerPivot and Custom PivotCharts
Guest Post by Colin Banfield [LinkedIn] In the next few posts, I plan on demonstrating techniques for creating various types of custom PivotCharts that use PowerPivot data and DAX measures. […]
Today’s Post Delayed
Yesterday I left Baltimore BWI airport at 11 am heading back to Cleveland. Like basically all of the East Coast air travelers yesterday afternoon though, I never made it home.
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