Kasper de Jonge posted a great article about building PowerPivot hierarchies against dimension tables that implement parent/child relatioship… Basically, a new PATH() DAX function is used to build a string that contains a path from the leaf to the top parent level member in the hierarchy and then a PathItem() function is used for each level in the PowerPivot hierarchy to extract the value.. brilliant and simple…