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

Course calendar
video courses
  DAX Patterns collection
  Intro to Data Modeling Free
  Data Modeling for Power BI
  Power BI Dashboard Design
  Introducing DAX Free
  Mastering DAX 2
  Optimizing DAX
  SSAS Tabular
  Power Pivot
Classroom courses
Check out the latest updates on our training page.


In this pattern, we show you how to compute time-related calculations, like year-to-date, same period last year, and percentage growth using a standard calendar.
Read more


Latest videos

DAX Patterns


Latest news
• Power BI Paginated Reports August 2020 updates
The latest version of Power BI Report Builder supports multi-value parameters for DAX, a new authentication type for Azure SQL DB and Azure Synapse, and Common Data Service data sources. This (paginated report) is no legacy technology at all!
Sep 4, 2020 · Microsoft
• MDX Studio
The new release of MDX Studio now has a single EXE to copy, several bug fixes, and a notification of new versions available. Thanks Alberto Spelta for working on version 0.4.50!
Sep 13, 2020 · SQLBI
• Power Query M Primer: Type System
If you are serious about Power Query, you cannot miss this series of articles explaining how M works from the ground up. Previous articles in the series cover functions, variables, types, tables, and error handling.
Sep 3, 2020 · Ben Gribaudo
• Tabular Editor 2.12.3
Since our latest newsletter, two updates of Tabular Editor were released with several fixes and new features for scripts.
Sep 11, 2020 · Daniel Otykier
• Optimizing the performance of Power Query merges in Power BI, part 5: cross joins
The latest part of the series dedicated to optimizing the merge operation in Power Query describes how to obtain a cross join in an efficient way.
Aug 30, 2020 · Chris Webb