| Order of Evaluation in CALCULATE Parameters |
| Written by Marco Russo |
| Wednesday, 02 May 2012 22:54 |
|
DAX is the new language used by PowerPivot and Analysis Services in Tabular mode and it resembles the syntax of Excel formula and it can be considered a functional language. You do not have iterative statements, but you can run iterative functions like, for example, SUMX and FILTER. The most important functions in DAX are CALCULATE and CALCULATETABLE, and these functions are also the most complex to master, because of the many operations they do. In order to fully understand them, you also have to well understand evaluation contexts (row context and filter context). Read more... |
Author articles
- Grouping Transactions by Age of Customers in DAX
- LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular
- SQL Down Under Podcast - Guest: Marco Russo
- Week-Based Time Intelligence in DAX
- The Right Version of Excel 2013 for using PowerPivot #powerpivot #excel
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?
