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
Transition matrix
The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals For example customers might receive a ranking evaluation every month or products might have a rating score measured every week Measuring the changes in… 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