| PowerPivot DAX: Find and Search in Denali |
| 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... |
Author articles
- Help, I received a pivoted data file that I want to combine with my data in PowerPivot
- When Importing from Tabular Model use DAX
- Analyze a Twitter feed with Excel 2013, DataExplorer and GeoFlow
- NBA team spending and their results with Excel, PowerPivot and Data Explorer
- What is eating up my memory the PowerPivot / Excel edition
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
