There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a limited unidirectional relationship. In this article, we compare the performance of both options. Our readers know… Read more
This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. Read more
This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. Read more
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. In this article we introduce the architecture of push datasets. Read more
The New and returning customers pattern helps in understanding how many customers in a period are new returning lost or recovered There are several variations to this pattern each with different performance and results depending on the requirements Moreover it… More on DAX Patterns
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more
Marco Russo & Alberto Ferrari
Mar 15-17 - New York City
May 11-13 - Sydney