Amsterdam, NLFinding products without sales by using DAX
Marco Russo & Alberto FerrariThis article analyzes the performance of different DAX techniques to identify any products without sales in an area or a time period. Read more
Using DAX to control a chart range in Power BI
You can rely on DAX expressions to control the behavior of some aspects of Power BI visuals. This article shows a few examples of managing the range of charts. Read more
Nov 1-3 - Palo Alto
Dec 5-7 - Cologne
Video Training
Introducing DAX Video CourseFree
SqlBits 2024 Unveiled
Marco RussoIf there is a conference you should attend at least once, it is SqlBits. Why? Because it is magic. It is impossible to imagine organizing such an international event with a team of volunteers. It is against common sense actually… Read more
Managing hierarchical organizations in Power BI security roles
This article describes how to apply dynamic security roles in a hierarchical organization to minimize the maintenance effort on the security configuration and obtain the best performance at query time. Read more
DAX Patterns
Custom time-related calculations
This pattern shows how to compute time-related calculations like year-to-date same period last year and percentage growth using a custom calendar This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal calendar… 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