Topic: DAX

        Page 34 of 409 posts
article –

Usage of dates argument in a row context

Several Time Intelligence functions in DAX use a <dates> argument, which has a special behavior because it can be expressed by using both a column reference syntax, a table expression or a Boolean expression.  Read more

video –

DAX Evaluation Context

Learning evaluation contexts in Data Analysis Expression (DAX) is fundamental to understanding the behaviour of this language, and to being able to write correctly functioning formulas for your desired calculations. Marco Russo teaches you these important concepts in this 50-minute…  Watch now

article –

Best Practices Using SUMMARIZE and ADDCOLUMNS

Everyone using DAX is probably used to SQL query language. Because of the similarities between the Tabular data modeling and the relational data modeling, there is the expectation that you can perform the same operations as those allowed in SQL.…  Read more

blog post –

New videos available #dax #ssas #powerpivot

The collaboration I and Alberto started with Project Botticelli is starting producing content. At this point we have three videos available: DAX in Action shows the power of DAX in PowerPivot solving common patterns not so easy or fast to solve in other  Read more

video –

Introduction to DAX

Introduce yourself to Data Analysis Expression (DAX) by learning the syntax and the fundamental functions of this language in this 40-minute video.  Watch now

white paper –

VertiPaq vs ColumnStore Comparison

SQL 2012 gives you two different xVelocity engines, with different capabilities and different scenarios of implementation, the paper will help you choose the right one or, at least, raise your curiosity about performing more tests on your specific scenario.  Read more