Amsterdam, NLUsing DAX to control a chart range in Power BI
Marco Russo & Alberto FerrariYou can rely on DAX expressions to control the behavior of some aspects of Power BI visuals. This article shows a few examples of managing the range of charts. Read more
SqlBits 2024 Unveiled
Marco RussoIf there is a conference you should attend at least once, it is SqlBits. Why? Because it is magic. It is impossible to imagine organizing such an international event with a team of volunteers. It is against common sense actually… Read more
Sep 27-29 - Chicago
Dec 5-7 - Cologne
Video Training
Introducing DAX Video CourseFree
Managing hierarchical organizations in Power BI security roles
This article describes how to apply dynamic security roles in a hierarchical organization to minimize the maintenance effort on the security configuration and obtain the best performance at query time. Read more
Differences between GROUPBY and SUMMARIZE
Both GROUPBY and SUMMARIZE are useful functions to group by columns. However, they differ in both performance and functionalities. Knowing the details lets developers choose the right function for their specific scenario. Read more
DAX Patterns
Comparing different time periods
This pattern is a useful technique to compare the value of a measure in different time periods For example we can compare the sales of the last month against a user-defined period The two time periods might have a different… 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