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
Standard time-related calculations
In this pattern we show you how to compute time-related calculations like year-to-date same period last year and percentage growth using a standard calendar The great advantage of working with a standard calendar is that you can rely on several… 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