This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER.  Read more

This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI.  Read more

A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order.  Read more

This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships.  Read more

This article describes how to control format strings in calculation groups. Before starting, we suggest you read the previous articles in this series.  Read more

Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required.  Read more

This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic.  Read more

Power BI sets a new milestone in Business Intelligence: Marco describes the importance of new composite models in an article, and Alberto shows them in action in a video.  Read more

This article describes the memory configuration in SQL Server Analysis Services and Azure Analysis Services. Modifying these settings may impact performance and memory errors.  Read more

This article describes how to implement currency conversion for reporting purposes in Power BI.  Read more