Topic: BISM

        Page 2 of 75 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

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

blog post –

Optimize Many-to-Many with SUMMARIZE and Other Techniques

We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships  Read more