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)

Read more...

 

Tags: performance, dax, excel

 

2007-2015 VidasSoft Systems Inc.