Amsterdam, NLAll the secrets of SUMMARIZE
Alberto FerrariSUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. Read more
Setting the right permissions for users of composite models
Marco RussoWhen you create and publish a composite model using DirectQuery for Power BI datasets and Analysis Services, you should pay attention to the minimal permissions required to consume data. For example, consider the following scenario: Base is a shared dataset… Read more
Oct 13-15 - New York City
Nov 10-12 - Sydney
Video Training
Introducing DAX Video CourseFree
Development Tools for Power BI and Analysis Services models – Live Event
Past are days of creating data models with a single monolithic tool provided by Microsoft. The required toolbelt includes multiple tools. Most of them are free and open-source. Watch the recording of the SQLBI live event delivered on Wednesday May… Read more
Show previous 6 months of data from single slicer selection
Marco Russo & Alberto FerrariIn this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. Read more
DAX Patterns
Currency conversion
Currency conversion is a complex scenario where both the data model and the quality of the DAX code play an important role There are two kinds of currencies the currency used to collect orders and the currency used to produce… 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