P3 Adaptive
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.
The first thought to occur to me was “well, for each Year&WeekOfYear, I just want to grab the max date”. That sounded easy enough… EARLIER() no longer scares me
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.
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 […]
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?
Picking up from Tuesday’s post, which drew some quick comments, let’s add one more function to our evaluation: HASONEFILTER().
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.
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.
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.