Display problems? View this newsletter in your browser.

SQLBI

Mar 4, 2014


NEXT EVENTS:
Mar 17
Advanced DAX Workshop

Amsterdam, NL
Apr 1
SSAS Tabular Workshop

Antwerp, BE
Apr 14
PowerPivot Workshop

Online, US Time
NEW DAX PATTERNS:
Parameter Table


The Parameter Table pattern is useful when you want to add a slicer to a PivotTable and make it modify the result of some calculation, injecting parameters into DAX expressions.


Static Segmentation

The Static Segmentation pattern groups a continuous numeric value in a finite number of clusters by using a configuration defined in a parameter table.
The static segmentation happens in a calculated column that is useful when you want to filter and group data according to the range of values.
The parameter table is invisible and used only to control the segmentation algorithm.
FILTER vs CALCULATETABLE:
optimization using cardinality estimation


A common best practice is to use CALCULATETABLE instead of FILTER for performance reason.
This article by Marco Russo explore the reasons of that and explain when FILTER might be better than CALCULATETABLE.

» READ ARTICLE
ADVANCED DAX WORKSHOP:
Last seats in Amsterdam


Just a few seats remaining for our advanced DAX course on Mar 17-18-19 in Amsterdam.
Don't miss it: hands-on-lab with our experts included!

» REGISTER NOW
EARLY BIRD EXPIRING:
SSAS Tabular Workshop


Don't miss 3 days of Tabular modeling in Microsoft SQL Server Analysis Services with our certified experts, on Apr 1-2-3 in Antwerp, BE.

Don't wait too long, the Early Bird expires next week!

» REGISTER NOW AND SAVE 300€




SQLBI is a brand of Loader. 2006-2014 © All rights are reserved.
We are Microsoft SSAS Maestro        We are Microsoft Gold Partner in Data Platform + Business Intelligence        We are Microsoft Most Valuable Professional
You are receiving this mail because we have registered your interest in SQLBI.
If our records are wrong or you'd like to make a change to the type of emails you receive, unsubscribe