Surveying DAX functions

When you want to summarize your PowerPivot data you can use the built-in…DAX functions to do so.…There are two ways to find the functions you need.…The first is to use the Help system to look up the function you want and the…second is to start typing the function's name and select the proper function…from the IntelliSense list that appears.…You're probably familiar with Formula AutoComplete and IntelliSense from using…Excel, so I'll show you how to use the PowerPivot Help system to get information…on the available functions.…To begin, in Excel we'll click the PowerPivot tab on the Ribbon and then click…the PowerPivot Window button.…

And when we do, our data model appears inside of the PowerPivot window.…Now to get help in PowerPivot you can click the Help button and it's the blue…button with a question mark at the top right corner of the Ribbon.…So click that and the SQL Server PowerPivot for Microsoft Excel Help dialog box appears.…Then inside the dialog box click the Search tab in the left-hand pane and…