Data Analysis Expressions
PowerPivot is uniquely suited as a business intelligence development tool in the ability to combine large volumes of disparate yet related data. To this point, our examples have steered clear of an issue that will occur in all but the most trivial business intelligence solutions: the need to create custom measures, or calculated columns, based on the source data. Recognizing this, Microsoft has included a set of functions, known as Data Analysis Expressions (DAX), capable of creating calculations that may not be present in the original source data.
KeywordsTransportation Sorting Prefix
Unable to display preview. Download preview PDF.