This article describes how to use DAX calculated columns to sort names that look like duplicates at a certain level of a hierarchy, but are unique when considering their full path within the hierarchy.
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
• DAX Studio 2.11 release
The new version of DAX Studio has a countless number of improvements and two new features in preview: Query Benchmark and Query Builder. Yes, a DAX query builder landed in DAX Studio. It's the first version and it's in preview, but it's a good reason to upgrade, isn't it? If you are insatiable, enjoy the new Partitions tab in View Metrics and in VertiPaq Analyzer.
Jun 7, 2020 · Darren Gosbell
• Cast your vote for DAX calculations at the visual level of reports
Our proposal for DAX calculations at the level of visuals in reports has received over 1,000 votes in 10 days. The idea is ranked #30 in the top ideas for Power BI. That is an excellent result, but we need another 2,000 votes to be in the top 10. Every vote counts, and your vote is just one click away. Thanks!
Jun 8, 2020 · Marco Russo
• Power BI Report Server May 2020
The new version of Power BI Report Server includes many of the features released in Power BI Service in the last few months. One word of caution: version 15.0.1103.227 seems to force sign-in in Power BI Desktop with custom visuals and there could be a bug when uploading model changes to existing datasets. Do your tests before going in production, or wait for a new build.
May 28, 2020 · Microsoft
• Selectively show report pages for specific users in Power BI
Gilbert Quevauvilliers explains how to control which users will see which pages in a report. This goal is achieved by using a combination of Row-Level Security (RLS) and conditional formatting. The article describes the process step by step; it is not trivial but it is well explained.
May 26, 2020 · Gilbert Quevauvilliers
• Importing Office Forms data into Power BI
Rui Romano shows you how to automate the import of Office Forms data into Power BI. The process is much easier than it seems; however, it is just the lack of a specific user interface that is challenging here. But Power Query is your friend.
Jun 3, 2020 · Rui Romano
• Tabular Editor 2.10.0
The latest version of Tabular Editor offers a new organization of property categories. It also offers better support to the latest compatibility levels and the enhanced metadata format (v3) to deploy to Power BI Premium. And many small fixes and improvements, as always.
Jun 4, 2020 · Daniel Otykier
• Service Principal access to dedicated capacity XMLA endpoint
Daniel Otykier describes in detail how to enable Service Principal access to a Power BI workspace in a dedicated capacity - Power BI Premium or embedded/A SKU. This was the missing part required to run unattended deploy or refresh operations via XMLA endpoint. Yes, continuous integration is now possible!
Jun 4, 2020 · Daniel Otykier
• Optimizing the performance of Power Query merges in Power BI
Chris Webb wrote a two-part article describing how to optimize merge operations in Power Query. This technique can be applied to non-foldable data sources like CSV files. Very valuable information.
Jun 3, 2020 · Chris Webb
• Updated whitepaper: Planning a Power BI enterprise deployment
The third version of the Microsoft whitepaper, "Planning a Power BI Enterprise Deployment" is available. This article recaps the changes made in each section and provides a link to download the complete whitepaper in PDF format.
Jun 3, 2020 · Melissa Coates
• How to be alerted when Power BI tenant settings change
Melissa Coates explains how to receive an alert when a tenant setting has changed in the Power BI Service. If you want to keep the situation under control, this is a must-read.
Jun 4, 2020 · Melissa Coates

DAX Guide