Avoiding calculated column in DAX

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

A calculated column is a DAX expression which is evaluated when the PowerPivot workbook is updated. It is very useful, but there are cases where you want to delay calculation at query time. For example:

  • You want to make part of the calculation depending on the selection in the PivotTable (i.e. selecting a scenario for a simulation)
  • You want to avoid the storage of another column in the PowerPivot workbook (it has a cost in terms of space, after all)



Tags: performance, dax, excel


2007-2015 VidasSoft Systems Inc.