Surveying DAX functions


show more Surveying DAX functions provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

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 ...

Surveying DAX functions
Video duration: 2m 40s 3h 43m Intermediate

Viewers:

Surveying DAX functions provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...