Copenhagen, DK200th SQLBI Newsletter
January 16, 2014 was the day we at SQLBI sent out our first newsletter. We had less than 8,000 subscribers back then. We went on to send newsletters out every other week for more than seven years, always trying to… Read more
Controlling drillthrough in Excel PivotTables connected to Power BI or Analysis Services
Marco Russo & Alberto FerrariThis article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. Read more
Mar 15-17 - New York City
May 11-13 - Sydney
Sep 30-Oct 2 - Amsterdam
Video Training
Introducing DAX Video CourseFree
Deep dive into measure filters in Power BI Desktop
When you use a measure as a filter in a Power BI visual, the DAX code generated might display different behaviors depending on whether the measure is part of the values shown in the visual or not. In this article,… Read more
Launching the Mastering Tabular video course
The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! Read more
DAX Patterns
Budget
This pattern includes several coding techniques you may find useful for budgeting scenarios The techniques do not apply only to budgeting We use the budget as an example to show how to reallocate a measure at a different granularity and… 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