This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt.
Read more


The RANKX function in Power BI might display an unexpected behavior when applied to a column that has a specific sort order in the data model. This article explains why, and how to address this issue.
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
• Naming tables, columns, and measures in Power BI
This post from Chris Webb introduces a discussion that deserves a longer article, if not a book by itself: A model should use proper names for all the objects. If you have Power BI models with table names starting with Dim or Fact, reading this article is mandatory.
Jun 28, 2020 · Chris Webb
• Power Query data privacy settings deep dive
If you have to deal with the Power Query data privacy settings in Power BI (ever seen a Formula.Firewall error?) watch the video recording of this session delivered by Chris Webb at the London Power BI user group.
Jun 21, 2020 · Chris Webb
• Tabular Editor 2.11.5 is ready for Power BI Desktop integration
In the last two weeks, several updates and bug fixes were made to Tabular Editor. The upcoming version of Power BI Desktop in July should include the integration with external tools, and the latest Tabular Editor already supports that feature.
Jun 30, 2020 · Daniel Otykier
• Power BI CLI - command line interface
Power BI CLI is a multiplatform command-line tool used to interact with the Power BI REST API. It is a work in progress with minimal documentation, but if you want to import a PBIX file with a command-line tool, this is the way to go.
Jun 15, 2020 · Jan Pieter Posthuma
• Adopting Tabular Editor as primary model design tool
Paul Turley wrote a blog post explaining why he has given up on Visual Studio to create Tabular models. For the same reasons, you are likely to adopt Tabular Editor as the primary tool to maintain a model in Power BI Desktop starting from the upcoming July 2020 release.
Jul 3, 2020 · Paul Turley
• Power BI theme templates
This useful GitHub repository contains snippets to assemble Power BI Themes. If you have ever struggled with the formatting options of the visuals in a theme file, you will appreciate this useful resource.
Jun 26, 2020 · David Eldersveld

DAX Guide