A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in detail the KPI settings needed to get the best result using Power BI and Excel as clients.
Read more


This article shows two techniques based on calculation groups: how to implement dynamic format strings in regular measures, and how to perform weight conversion on the fly.
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.
Learn DAX


The Dynamic segmentation pattern is useful to perform the classification of entities based on measures. A typical example is to cluster customers based on their spending volume. The clustering is dynamic, so that the categorization considers the filters active in the report. Indeed, a customer might belong to different clusters on different dates.
Read more


Latest videos


Latest news
• Power BI October 2020 update
Besides many incremental improvements, this monthly release contains important new features in Power Query: dynamic M query parameters and automatic table detection from Excel and JSON files. Don't just stop at the new logo icon!
Oct 20, 2020 · Microsoft
• On-premises data gateway October 2020 update
Besides the monthly announcement of a new data gateway update, the important takeaway is the .NET Framework requirement starting in January 2021. Check now whether you might have support issues on your gateway server before it is too late!
Oct 14, 2020 · Microsoft
• Doing Power BI the right way: validating data model results
Paul Turley covers an important part of data model development: validating the numbers. Sometimes, this can be the most expensive side of a project. This is especially true when it is not planned in advance and an inaccurate calculation reaches a report in production, thus leading to wrong decisions. Make this validation a part of the regular development cycle.
• DAX Studio 2.13 released
Improvements all the way: query builder, export data, view metrics, connection reliability, and much more. You can read the full details in Darren's blog post, but in any case, you absolutely have to update DAX Studio to the latest version.
No, not tomorrow, do it now!
Oct 20, 2020 · Darren Gosbell
• VertiPaq Analyzer 2.0 preview 5
This should be the last preview release of VertiPaq Analyzer 2.0. The Relationships page now shows many-to-many cardinality relationships and bidirectional filters with different graphics and the ability to quickly filter these elements in large data models.
Oct 24, 2020 · SQLBI
• Use Visual Studio Code to create Power BI External Tool
Developers can create external tools for Power BI using Visual Studio Code. Phil Seamark explains how to create an application that shows up in the External Tools ribbon of Power BI Desktop.
Oct 19, 2020 · Phil Seamark
• Chris Finlan at Raw Data by P3
Chris Finlan (product manager for Paginated Reports) and Rob Collie (former PM for Power Pivot for Excel) talk about the evolution of Paginated Reports, the licensing of Premium per user, and the challenges of being a program manager for widely-adopted software. It is an entertaining one-hour podcast we hope you will enjoy.
Oct 20, 2020 · Chris Finlan
DAX Patterns