Munich (München), DEVariables in DAX
Marco Russo & Alberto FerrariUsing variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why they are so important in any DAX expression. Read more
Rolling average with working days in DAX
Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the working days. Read more
Nov 9-11 - Chicago
Dec 5-7 - Amsterdam
Sep 28-30 - Brisbane
Video Training
Introducing DAX Video CourseFree
The Whiteboard video series on the SQLBI YouTube channel
Marco RussoThe Whiteboard is a new series on the SQLBI YouTube channel where I use a whiteboard to describe abstract DAX and Tabular concepts in a more interactive way. I usually represent these concepts by drawing on a whiteboard in our… Read more
Hiding measures by using object-level security in Power BI
This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. 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