Topic: SSAS

       Page 3 of 43 articles
article –

Translations in Analysis Services 2016

Translations are a new feature in Analysis Services Tabular 2016. This article explains how to use this feature and introduce SSAS Tabular Translator, a free tool to edit translations files.  Read more

article –

Optimizing DAX expressions involving multiple measures

Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter…  Read more

article –

Many-to-many relationships in Power BI and Excel 2016

The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described in this article.  Read more

article –

Transition Matrix Using Calculated Tables

In the 2015 September update, Power BI introduced calculated tables, which are computed using DAX expressions instead of being loaded from a data source. This article shows the usage of calculated tables to solve the pattern of transition matrix for…  Read more

article –

Calculated Columns and Measures in DAX

One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recaps the differences and describes when to use each one.  Read more

article –

Data Model Size with VertiPaq Analyzer

Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.  Read more

article –

DIVIDE Performance

The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are exceptions to this rule, described in this article through a simple performance analysis.  Read more

article –

Last Process Date in SSAS Tabular

How do you get the last process date for an SSAS Tabular Database? This article shows the techniques you can use and explains how to interpret the information available.  Read more