article –
Introducing LOOKUPVALUE
This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt. Read more
article –
Distinguishing HASONEVALUE from ISINSCOPE
This article describes the differences between HASONEVALUE and ISINSCOPE, which are two useful DAX functions to control the filters and the grouping that are active in a report. Read more
Video –
May 23, 2020
Query Performance Tuning in DAX Studio
More videos
Sep 21-23 - New York City
Feb 17-19 - Sydney
Sep 7-9 - Munich
Sep 22-24 - Amsterdam
Video Training
Introducing DAX Video CourseFree
article –
Sorting duplicated names in a level of a hierarchy with DAX
This article describes how to use DAX calculated columns to sort names that look like duplicates at a certain level of a hierarchy, but are unique when considering their full path within the hierarchy. Read more
blog post –
Optimizing access to Azure Data Lake Storage (ADLS) Gen 2 in Power Query
Marco RussoI recently implemented Power BI models by extracting data from Azure Data Lake Storage (ADSL) Gen 2, and I wanted to share a lesson learned when using this connector. 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