Report Portal

PowerPivot calculated columns are not dynamic

A quick and dirty one - in attempting some clever dynamic security modelling in DAX I was warned about a gotcha in my design - that calculated columns were only evaluated when the model processed, so any approach based on calculated columns was doomed to failure. I didn't quite believe it so I decided to do a road test in PowerPivot. Using a simple data set of one Dimension and one Fact, like below:

Read more...

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.