Welcome to SQLBI+
Marco Russo & Alberto FerrariSQLBI+ is our new subscription service to advanced content that support professional model authors who create semantic models for Power BI and Analysis Services. Read more
Writing DAX Queries
Learn how to write DAX queries and how to manipulate tables in DAX measures and calculated columns. Read more
Dec 5-7 - Amsterdam
Mar 15-17 - San Francisco
Apr 17-19 - Copenhagen
Video Training
Introducing DAX Video CourseFree
Composite Models
Learn the internals of Power BI semantic models created by using VertiPaq, DirectQuery over SQL, and DirectQuery for Power BI datasets and Analysis Services. Read more
Introducing horizontal fusion in DAX
Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this article, we introduce this optimization with some examples. Read more
DAX Patterns
Survey
The Survey pattern uses a data model to analyze correlations between different events related to the same entity such as customer answers to survey questions For example in healthcare organizations the Survey pattern can be used to analyze data about… 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