Blogs from Wise Owl on DAX in PowerPivot 2010

Showing blogs 1-3 (out of 3)

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | DAX

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.

Tags:   PowerPivot 2010 | DAX

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.

Tags:   PowerPivot 2010 | DAX
This page has 0 threads Add post