EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603
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…
business intelligist 