Leveraging DAX query tables for staging Data Transformations
User Rating: / 0
PoorBest 
Written by Javier Guillen   
Tuesday, 15 January 2013 21:12

When designing a data warehousing solution, it is typical to allocate certain data transformations to the ETL layer, particularly those that would be easier or more efficient to do outside of the cube. At the same time - prior to Excel 2013 release - developing multi-step data transformations in a Data Model was, whenever possible, a factor that increased the complexity (and lowered maintainability) of DAX formulas.

Read more...

 

Tags: dax, load, tabular
 

XL Cubed