Project Botticelli

Handle Hierarchies in Power Pivot or SSAS with DAX

10 December 2013 · 539 views

Clever DAX formulas to handle complex hierarchies

DAX LogoMarco Russo, DAX and tabular modelling expert from explains that, contrary to general opinion, handling even complex hierarchies, such as parent-child ones, in Data Analysis Expressions can be easy. There are a few interesting formulas that you need to be aware of, and a particular use of traditional bridge tables, to enable sophisticated hierarchical navigation and computation in Power Pivot or in SQL Server Analysis Services Tabular. To help you learn this, we have just published two new videos by Marco:

The first one is free to watch, and the second one requires a Full Access Membership. As this is the traditional time of the year when training budgets are considered, may I suggest that you consider joining, or extending your membership, for a full 1-year, to take advantage of the new BI videos, which we have published every month. An annual membership is our best value, and it is even available to groups of people interested in learning cutting-edge BI.

Our online DAX course is quite extensive now, with 12 modules and 7-hours of high-quality material, but there is more to come.