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
Month-related calculations
This pattern describes how to compute month-related calculations such as year-to-date same period last year and percentage growth using a month granularity This pattern does not rely on DAX built-in time intelligence functions You can use the Month-related calculations pattern… 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