Wham! It's a hands-on technique! In a recent post, I hinted that I’d be using the Football Project V2 as my “platform” for some future techniques-oriented posts. That future starts today! And while I certainly have enjoyed writing my more…
I’m going to keep today’s post short and sweet. The #1 missing feature in Power BI is overwhelmingly clear to me, #2 isn’t close, and addressing this should be quite simple for my friends and former colleagues at Microsoft. “Help…
In this Report, We Are Only Seeing Customers Who Have Purchased
Both Accessories AND Clothing During 2004
A Post From Oceanside!
Yeah, I’m on vacation (my first real vacation in 5+ years), so why am I writing a post? Well, it’s before 9 am, the family is still sleeping in, and I honestly loved the idea of slipping out to write a post while looking at the ocean.
The truth is I LOVE writing these posts – in some sense they represent Peak Fun for me, especially when they can be written at a relaxed pace with no outside pressures. In the future, maybe I will take vacations for the express purpose of writing. (That sounds surprisingly good to me actually).
Slicers – The More You Select, the More You “Get”
Un. Freaking. Believable.
(See bottom of post for video of this in action!)
Back to Our “Regular” Programming Today
First of all, THANKS for being patient with the promos for PowerPivotPro University – we do have to pay the bills here of course, AND I have poured six months of my best work into it, so thanks for giving it your consideration.
But yeah, it’s time to get back to some serious magic tricks with data.
A Funny Thing Happened On Reddit and Twitter…
I don’t play Pokemon – neither the video nor card game variety. But I recognize my kind of sickness (cough cough fantasy football) when I see it.
And people who know me, ALSO know my sickness. So they point things out to me:
And that led me to this Reddit thread: Pokemon & Power Pivot…
Building on a Popular Technique
Last week’s post on “CONTAINSX” proved to be quite popular. In the comments, Sasha provided an alternate formula that used FILTER instead of SUMX. Honestly I have a been of a “fetish” for SUMX – after all it IS the 5-Point Palm Exploding Function Technique – so at first I was like “nice work Sasha but I’m sticking with my SUMX.”
But then “en” asked if we could write a formula that reported what the matching keyword actually WAS – not just whether there WAS a match.
And then, Sasha’s formula came in super-handy. A couple of quick mods and we were in business. Read on for the formula, but first, a quick aside.
Another thing that is easier in Power Pivot than “Traditional” Excel
I really enjoyed the comments (and the emails) we received about the CONTAINSX post. Here are two of my faves:
Gantt Chart with Resource Loading Report
The response to POST 1 of this Gantt Chart mini series was swift and it didn’t take long for Vegard to contact me with a query regarding resource loading. Vegard had quickly taken the template and adapted it to include resource hours. The issue existed with getting the total hours for each resource to behave the way he wanted. Naturally, individuals will normally work for a set expected amount of time per day and if tasks are planned which exceed that expectation, it’s obvious that they might not get the work done!
In this post, I’ll start to explain how to adapt the model from the previous post to include resource loading and associated subtotals per individual resource.
A recent comment/question alerted me to the fact that I’ve never devoted a post just to this very useful (and often misunderstood) function. Time to correct that.
The #1 Reason to Use FILTER – When CALCULATE Breaks Down
Does this Mysterious Error Look Familiar?