We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
    142 articles
article –

Understanding data lineage in DAX

Data lineage is such a well-implemented DAX feature that most developers use it without knowing about it. This article describes data lineage and how it can help in producing better DAX code.  Read more

article –

Bidirectional relationships and ambiguity in DAX

Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models as numbers become unpredictable. This article provides a deep explanation of the kind of ambiguity that might appear…  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 –

Displaying Nth Element in DAX

This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties.  Read more

article –

Understanding DAX Auto-Exist

This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI.  Read more