DIVIDE() and Conquer
User Rating: / 0
PoorBest 
Written by Rob Collie   
Saturday, 27 July 2013 17:10

The Old Way: IF()

Since 2009, here's how I have been handling this in my PowerPivot measures:

[Growth vs Last Year] = IF([Units Sold Last Year]=0, BLANK(), ([Units Sold]-[Units Sold Last Year])/[Units Sold Last Year] )
Read more...

 

Tags: dax, tabular
 

XL Cubed