Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
In this article we perform a performance comparison between header/detail models and star schemas. Building a star schema might require a few ETL steps and some coding. Nonetheless, it is always the best modeling option. Read more
In DAX, optimizations and data types do not always play nice and can leave you dealing with surprises. In this short article, we see an example of how mixing blanks, Boolean logic, and comparison with TRUE might lead to unexpected… Read more
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
This post introduces the four time-related calculations patterns presented in this website The goal here is to help you choose the right pattern based on your specific needs Indeed when it comes to time-related calculations the choice of the pattern… More on DAX Patterns
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
Amsterdam, NL
Marco Russo
Marco Russo & Alberto Ferrari
Mar 15-17 - New York City
May 11-13 - Sydney
Nov 30-Dec 2 - Copenhagen
Alberto Ferrari