PowerPivot DAX: Find and Search in Denali
User Rating: / 0
PoorBest 
Written by Kasper de Jonge   
Tuesday, 16 August 2011 20:16

In Denali we made a small (but significant) change to the Find and Search syntax. By adding a new optional argument "NotFoundValue" you can tell DAX to return a value instead of returning an Error when the value is not found. In 2008 R2 DAX would always return a Error.

Read more...

  Tags: v2, dax, design
 

Pyramid+PowerPivot