This article describes the differences between HASONEVALUE and ISINSCOPE, which are two useful DAX functions to control the filters and the grouping that are active in a report.
Read more


A long and entertaining blog post by Alberto Ferrari describing why DAX is simple, but not easy. The advice given here is based on the same secrets a seasoned coach would share with an eager young athlete.
Read more

Course calendar
video courses
  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.
Mastering DAX Video Course


Latest videos


Latest news
• Power BI Desktop June 2020
The new monthly release of Power BI Desktop introduces enhancements for mobile layout authoring, and important updates to the model view which is now available in live connect. You can see the relationships of the model you are consuming!
Jun 10, 2020 · Microsoft
• Split an existing Power BI file into a model and report
When you want to promote a PBIX file to a shared dataset, you often want to move the report part into another file. Steve Campbell explains how to split a PBIX file into two different PBIX files: one with the data model, the other with the report. This is also useful if you move the model to Analysis Services and you want to keep the layout of the report.
Jun 8, 2020 · Steve Campbell
• DAX Studio: How measure formatting works
Darren Gosbell describes in detail how DAX Studio formats measures included in query results. As a side note, there is a new version (2.11.1) with many fixes applied after the 2.11 release.
Jun 5, 2020 · Darren Gosbell
• Tabular Editor 2.11.0
Get ready for Power BI Desktop "External Tools" integration: The new version of Tabular Editor 2.11 is ready to keep the model synchronized between Power BI Desktop and Tabular Editor. Now we just wait for the next Power BI Desktop release!
Jun 21, 2020 · Daniel Otykier
• Optimizing the performance of Power Query merges in Power BI (Part 3 and 4)
Chris Webb added another two articles to the series describing how to optimize merge operations in Power Query. This time the focus is on join operations.
Jun 14, 2020 · Chris Webb
• Icon Map custom visual
James Dales created a web site to support the Icon Map custom visual for Power BI by using examples and use cases. If you want to plot data on a map, you should spend time on Icon Map.
Jun 15, 2020 · James Dales
• Improving the readability of the Matrix visual
Mark Walter wrote a long and detailed blog post with practical suggestions to improve the visualization of a matrix in Power BI, based on practical use cases. The solution to a problem can be creative thinking instead of a new visual property.
Jun 14, 2020 · Mark Walter
• Migrate Analysis Services models to Power BI using Tabular Editor
Marc Lelijveld published a step-by-step guide on how to migrate an existing Analysis Services model to Power BI. The same instructions are valid for on-premises and Azure versions of Analysis Services.
Jun 16, 2020 · Marc Lelijveld
• Power BI Report Server May 2020 - important update
If you have Power BI Report Server, make sure that you upgrade to the latest version 15.0.1103.232. It fixes important bugs that were present in the previous version, 15.0.1103.227.
Jun 15, 2020 · Microsoft
• Buy and apply Power BI Premium license
Seth Bauer introduces the differences between P sku (Power BI Premium licenses) and A sku (Azure capacity for Power BI Embedded). He explains how to apply the capacity to individual workspaces.
Jun 16, 2020 · Seth Bauer

DAX Guide