article –
DAX 101
Using CONCATENATEX in measures
This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. Read more
article –
Introducing Calculation Groups
This article is the first of a series dedicated to calculation groups in DAX. This introduction explains the capabilities of this feature and how to create calculation groups in a Tabular model. Read more
Video –
Apr 15, 2019
Aggregations in Power BI
More videos
Jul 23-25 - Melbourne
Oct 30-Nov 1 - San Francisco
Nov 26-28 - Amsterdam
Video Training
Introducing DAX Video CourseFree
article –
Importing Performance Analyzer data into DAX Studio
This article describes how to import into DAX Studio the performance metrics that can be exported by the Power BI Performance Analyzer, simplifying the analysis of slower queries in a report. Read more
article –
Introducing the Power BI Performance Analyzer
This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. 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
Analyzing Data with Power BI and Power Pivot for Excel
How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. Read more