article –
Strong and weak relationships in Power BI
This article describes what weak relationships are and the differences between strong and weak relationship in Power BI and DAX. Read more
blog post –
VertiPaq Analyzer 2.0 Preview 1
Marco RussoIn 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI. Read more
Video –
Aug 5, 2019
My Power BI Report is Slow – What Should I Do?
More videos
Oct 30-Nov 1 - San Francisco
Nov 26-28 - Amsterdam
Oct 22-24 - Copenhagen
Video Training
Introducing DAX Video CourseFree
article –
Creating a slicer that filters multiple columns in Power BI
This article describes how to create a slicer showing the values of multiple columns, applying the filter on any of the underlying columns. Read more
article –
Blank row in DAX
There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, explaining the details of the blank row added to tables for invalid relationships. Read more
DAX Patterns
ABC Classification – Dynamic
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
Book –
Microsoft Press
The Definitive Guide to DAX – 2nd Edition
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