This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships. Read more
This article explains the behavior of LASTNONBLANK, LASTNONBLANKVALUE, and similar DAX functions, also providing patterns for performance optimization. Read more
This article describes how to write efficient DAX expressions that compute the compound interest of incremental investments made throughout the holding period. Read more
This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI. Read more
The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern It groups items such as Products or Customers into segments based on their cumulated sales and how much they contributed to the total sales… www.sqlbi.com
The Definitive Guide to DAX (Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI) is the most comprehensive and authoritative guide to Microsoft’s DAX language for business intelligence and analytics. While other books cover only the basics, this guide offers expert guidance on everything intermediate-to-advanced Excel users and BI professionals need to know, from the basics to innovative high-performance techniques. Read more
Apr 15-17 - New York
Jun 3-5 - Amsterdam
Jul 22-24 - Sydney
May 13-15 - Calgary