article –
Understanding the difference between LASTDATE and MAX in DAX
This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. Read more
article –
Calculation Groups
Using calculation groups to selectively replace measures in DAX expressions
This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. Read more
Video –
Jul 15, 2020
Creating calculation groups in Power BI Desktop using Tabular Editor
More videos
Feb 3-5 - New York City
Feb 17-19 - Sydney
Sep 28-30 - Amsterdam
Oct 19-21 - Calgary
Video Training
Introducing DAX Video CourseFree
article –
Creating KPIs in Power BI Desktop
This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Read more
blog post –
Default calculation item in calculation groups
Marco RussoPower BI offers several options to create filters and slicers in a report. However, it is not possible to define a default filter at the model level so that every new report on a dataset automatically applies that filter. The… Read more
DAX Patterns
Transition matrix
The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals For example customers might receive a ranking evaluation every month or products might have a rating score measured every week Measuring the changes in… www.daxpatterns.com
Book –
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