## Category: DAX

### DAX – SUM, SUMX or CALCULATE()…Choices, choices!

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?

Written by on October 23, 2014

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

Written by on August 26, 2014

### 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.

Written by on August 21, 2014

### 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

Written by on June 28, 2014

### 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

Written by on April 29, 2014

### 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.

Written by on August 27, 2013

### 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().

Written by on March 21, 2013

### 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.

Written by on July 26, 2012

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

Written by on July 23, 2012

### 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

Written by on July 17, 2012

### Dynamic TopN Reports via Slicers, Part 2

OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique.  Slicer tables […]

Written by on July 5, 2012

### DAX – FILTER() – When, Why, & How to Use It

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.

Written by on June 14, 2012