Guest Post by Gil Raviv Intro: Many experts had proclaimed LongForm Journalism was headed towards extinction in the digital age. In fact it has found a new resurgence and a […]

I was recently helping a forum member at https://powerpivotforum.com.au with a problem about how to dynamically calculate an employee’s age.

When I was working recently with a client, helping her remotely – I asked her to calculate the sum for sales amount in the table. She responded whether she should use SUM, SUMX or CALCULATE?

It’s the same old story, I mashed and twisted some data through Power Query, pulled it through Power Pivot, spent hours creating calculated columns and measures, made a really nice Pivot Table with conditional formatting and all the bells and whistles.

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.

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.

Continuing the series of guest posts that got temporarily shelved, today we have one from Vivek Gargav.

’ve been getting this question a lot lately:  How does Power View relate to PowerPivot?  Is PV a replacement for PP?

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

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.