dax

Display # 5 10 15 20 25 30 50 100 All

Time Intelligence in Power BI Desktop

Written by Vidas Matelis on 07 March 2016.

"CONTAINSX" - Finding if a value in table 1 has a matching value in table 2

Written by Rob Collie on 29 January 2014.

"CONTAINSX" Revisited: What WAS the Match?

Written by Rob Collie on 29 January 2014.

"DAX Reference" - free online chapter from the book "Professional Microsoft PowerPivot for Excel and SharePoint"

Written by Denny Lee on 04 June 2010.

"Mark as Date Table": When not to use it

Written by Javier Guillen on 17 July 2012.

"Normalize" Your Measures for Fun and Profit!

Written by Rob Collie on 29 September 2013.

% of change since first month of the year using DAX and Power Pivot

Written by Kasper de Jonge on 07 April 2014.

10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)

Written by Vidas Matelis on 26 October 2015.

4 recommended practices for new DAX users

Written by Vidas Matelis on 08 June 2016.

5 Useful Data Analysis Expressions (DAX) Functions for Beginners

Written by Vidas Matelis on 08 March 2017.

A Different Approach To Last-Ever Non-Empty in DAX

Written by Chris Webb on 15 January 2013.

A Double CALCULATE Solves a SUMX Problem

Written by Vidas Matelis on 31 May 2016.

A mystifying and awesome solution for many 2 many

Written by Rob Collie on 29 November 2012.

A Simple Trick for Combating "Stale" Slicers

Written by Rob Collie on 04 December 2013.

A Treatise on the ALL() Function in DAX – or – ‘Is it all er nuthin’ with you?’

Written by Erika Misner on 08 April 2010.

ABC Analysis in PowerPivot

Written by Marco Russo on 19 January 2010.

ABC Classification

Written by SQLBI on 19 April 2014.

ABC Classification - Dynamic

Written by Gerhard Brueckl on 22 January 2015.

Accumulate values (running value) over multiple years in PowerPivot using DAX

Written by Kasper de Jonge on 14 September 2010.

Active day count in DAX

Written by Javier Guillen on 24 April 2012.

• 1
• 2
• 3
• 4