## Category: DAX Table Functions

### Navigating DAX Function Types: A list of DAX Scalar and Table functions

Let’s start off today’s post with a pop quiz. Once you’ve answered, click here to see the poll results, and then scroll down to see the correct answer

Written by on June 5, 2018

### Coffee Talk: DAX Pros

n today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment.

Written by on January 18, 2018

### SUMMARIZE() & ADDCOLUMNS() aren’t scary… if you can SEE them!

I tried solving this problem and the internet led me to SUMMARIZE(). It was stuffed inside another function and it confused me

Written by on December 14, 2017

### DAX Reanimator Series: Top Performers using SUMMARIZE

Welcome back P3 Adaptive nation, today I’d like to demonstrate some exciting ways to show Top Performing “things” using DAX. Most of what we’ll discuss has been covered before in […]

Written by on September 28, 2017

### Rediscovering (fire)matting: a truly amazing BI “tool”

This automatic BI tool has saved me innumerable hours each month and I find this useful for at least 80% of my DAX formulas.

Written by on April 20, 2017

### Nested SUMX or DAX Query?

I was helping a friend out recently with an interesting problem.  It all started with a SUM( ) that wasn’t behaving.

Written by on August 6, 2015

### Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine

Intro from Rob: Today I’m interviewing Chris Finlan of Microsoft about MS’s recent acquisition of Datazen, and what this means to us in the Power Pivot and Power BI community.

Written by on May 12, 2015

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