Analyzing the parallelism of storage engine operations in DAX Studio
Marco Russo & Alberto FerrariThis article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. Read more
How to enable the Single Value option in a Power BI slicer
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
Mar 15-17 - New York City
May 11-13 - Sydney
Video Training
Introducing DAX Video CourseFree
Creating real-time dashboards in Power BI with push datasets
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
Implementing real-time updates in Power BI using push datasets instead of DirectQuery
Marco RussoPush datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
DAX Patterns
Week-related calculations
This pattern describes how to compute week-related calculations such as year-to-date same period last year and percentage growth using a week granularity This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal… More on DAX Patterns
SQLBI Corp.
DAX Patterns, Second Edition
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