DIVIDE() and Conquer
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...