Parent-Child hierarchies in Excel!

This is really cool – I had completely missed it so far. The SQL Server 2012 release of PowerPivot for Excel includes several DAX functions (PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, and PATHLENGTH) dedicated to dealing with parent-child relationships. Kasper de Jonge (Program Manager at Microsoft Analysis Services) has a tutorial. Of course this is also covered in Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model by Marco Russo, Alberto Ferrari and Chris Webb but I’m not even halfway through the book yet;-)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create your website at
Get started
%d bloggers like this: