BY TOPIC▼
ARCHIVED BLOGS▼
POWERPIVOT 2010 BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
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.