DAX – The Diabolical Genius of “SWITCH TRUE”
SWITCH() is still testing for equivalence! By providing the first argument as TRUE(), now each subsequent “test” will check for TRUE().
Category: Page Type
Displaying Top N, Bottom N, and “All Others”
If We Use Excel’s Built-In Top N Filter to See Our Top 1,000 Customers, It Hides the Other Customers Completely. But Using DAX, We Can Just “Split” the Audience into Two Groups.
DAX – SUMX of IF: A Perfect Blend of Simple & Sophisticated
In This Case, Getting the Grand Total Correct for Each Row Required SUMX It’s that time of year again… …when my love of spreadsheets actually translates into a love of […]
DAX – The Many Faces of VALUES()
aybe it is a sign of where I am on the Geek Scale compared to Rob, but where he considers EARLIER() to be a pretty hard function to understand, it just doesn’t bother me. At least it seems to have just one purpose in life.
DAX – “CONTAINSX” Revisited: What WAS the Match?
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
DAX – “CONTAINSX” – Finding if a value in table 1 has a matching value in table 2
These are a few of my favorite things… Perhaps the only thing that makes me happier than a new “X” function (I still badly want a CONCATENATEX) is “inventing” a new one (like we’ve seen with PRODUCTX).
DAX – Week Ending Date Calculation
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 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.
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 […]
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().
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.