We just published the second edition of DAX Patterns! There is a new website with 23 patterns, a new book (420 pages), and a new collection of more than 16 hours of videos. Watch or read the complete announcement online.
Read more


This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor.
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
We are rescheduling courses as required by the ongoing situation, and in the meantime we have made sure to keep supporting our students on their learning path.
Check out the latest updates on our training page.
DAX Patterns video collection


Analyze in Excel for Power BI Desktop is an external tool for Power BI Desktop that with a single click, creates a new Excel PivotTable connected to the data hosted in Power BI Desktop.
Download now


Latest videos


Latest news
• Power BI Desktop August 2020 Release
The August 2020 release of Power BI Desktop introduces (in preview) the support for Perspectives. These can be created only in Tabular Editor for Power BI Desktop, or they can be present in a Tabular model published on Analysis Services. There is also a new lasso select for data points in a chart and the dynamic formatting of measures with calculation groups applied is not supported on more visuals - the previous July 2020 release supported only Matrix, Table, and Card visuals.
Aug 12, 2020 · Microsoft
• Default calculation item in calculation groups
The consumption experience of calculation groups should be improved by setting a default selection for a column in the model. This feature would also be useful in other scenarios without calculation groups. Marco explains why in a short post, asking for your vote!
Aug 15, 2020 · Marco Russo
• Creating multilingual Power BI datasets
Power BI models published on a dedicated capacity can display translated metadata: table names, column names, measure names, and so on. Daniel Otykier explains how to create and publish metadata translations using Power BI Desktop and Tabular Editor.
Aug 11, 2020 · Daniel Otykier
• Blocking classic workspace creation
It is somewhat funny that a new feature is a flag disabling another feature. However, the new workspace experience is now a reality and most of the time a classic workspace might already be in your "remove it" list. It is now possible to disable the creation of classic workspaces on a tenant if the company were to decide to go all-in with the new workspace experience. This small setting can save you many hours of troubleshooting.
Aug 6, 2020 · Microsoft
• The pros and cons of modelling measures as a dimension in Power BI
Creating a dimension of measures means applying the Entity Attribute Value (EAV) pattern in a Power BI model. Chris Webb explains and demonstrates why the EAV pattern is a very bad idea in Power BI and DAX.
Aug 9, 2020 · Chris Webb
• Power BI Dataflows: Multiple data lakes support
You can now map an existing Azure Data Lake Storage Gen2 (ADLS Gen2) to an individual workspace in Power BI, rather than having a single ADLS Gen2 account valid for all the Power BI Dataflows.
Aug 5, 2020 · Chris Webb
• Building cross-platform solutions that connect to Power BI datasets
Microsoft released the NuGet packages for .NET Core corresponding to existing ADOMD.NET and AMO for the .NET Framework. This new set of libraries makes it possible to programmatically interact with a Tabular model with technologies like Azure Functions, Linux, macOS, and any other cloud environment. A mandatory read for developers.
Aug 11, 2020 · Microsoft
• Power BI Developer community August 2020 update
If you develop solutions with Power BI Embedded, Power BI custom visuals, or you just use the Power BI REST API, don't miss the August news: new API, new free training, and new videos from Microsoft.
Aug 9, 2020 · Microsoft

DAX Patterns