Topic: Tabular

        256 posts
article –

Semi-Additive Measures in DAX

Values such as inventory and account balance, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX according to your specific requirements.  Read more

video –

Different types of many-to-many relationships in Power BI

The introduction of the weak relationships in Power BI composite models enables new data modeling techniques. However, not all of the many-to-many relationships can be managed by using weak relationship. The “classical” many-to-many relationships in data warehouse is a design…  Watch now

video –

Understanding relationships in Power BI

Relationships are the foundation of any Power BI or Analysis Services Tabular data model with multiple entities. At first sight, this is a trivial concept, especially if one has a knowledge of relational data modeling. However, the ability to create…  Watch now

blog post –

Calculation Groups in DAX – first impressions

Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it will have on Analysis Services and Power BI.  Read more

blog post –

What has happened in the DAX world in 2018

We are approaching the end of 2018, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2019. New DAX…  Read more

article –

Understanding numeric data type conversions in DAX

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages.  Read more

article –

Creating table functions in DAX using DETAILROWS

This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters.  Read more