Report Portal

Sorting duplicated names in a level of a hierarchy with DAX

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.

In a Tabular model and in Power BI, one column can be sorted using a different column. For example, we sort the month name by the month number, obtaining the sequence we are used to (January, February, March, …) instead of the default alphabetical sorting order (April, August, …). Generally speaking, the month number is the sort key, whereas the month name is the sorted column.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.