Blogs from Wise Owl on DAX in PowerPivot 2010

Using DAX Studio to edit calculated fields or measures in Excel

Posted by Andy Brown on 20 February 2015

The editor for calculated fields in Excel (aka measures) isn't the greatest; this blog shows you how to install and use DAX Studio as a substitute editor.

Using the RANKX function in PowerPivot DAX measures

Posted by Andy Brown on 04 November 2013

The RANKX function works out where a measure lies in order for any dimension, but it has a couple of gotchas to watch out for, as this blog explains.

How to use the RANKX function in PowerPivot

Posted by Andy Brown on 20 March 2013

This blog shows how to use each of the 5 arguments of the RANKX function to rank rows in PowerPivot.