Forum Discussion
Multiple level Hierarchy/Drilldown
Hi Anonymous,
Please refer to the online documents as below.
Understanding Functions for Parent-Child Hierarchies in DAX
Regards,
Frank
LivioLanzo......
My data table:
School ID Operations Air&Climate GreenhouseGas OutdoorAirQuality Buildings BuildingOperations
School A A AA AAA AAAA AB ABB
School B
School C
where,
A= AA+AB
AA = AAA+AAAA
AB=ABB
There are more sections to the hiearchy but they follow this same type of format. I figure if I can understand how this set of data should be formatted I will be able to apply it to the other categories.
Hope this helps, thanks!
Took a look an thank you so much for providing that, it was extremly helpful.
I was wondering though if you could link me to some documentation or further explain how the path column works in your items table?