DAX – the brain of a PowerPivot
With the release of PowerPivot in 2010, Microsoft also released programming language called DAX. Beside PowerPivot, DAX is also used in Microsoft SQL Server Analysis Services (SSAS). It’s a formula language which operates against the data model. What makes this language so special? Its ability to calculate complex formulas in a dynamic environment with …
