PowerPivot DAX: Find and Search in Denali

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.