In this video we will go through how to work with hierarchies using the following DAX functions:
PATH, PATHLENGTH, PATHITEM, PATHITEMREVERSE, PATHCONTAINS

The example used will be a simplified bill of materials (BOM) but in the microsoft documentation, there is an excellent example for employees and Managers.

Keynotes:

01:51 PATH
06:37 PATHLENGTH
07:31 PATHITEM
08:30 PATHITEMREVERSE
09:56 PATHCONTAINS


Link to Power BI file: https://gofile.me/2kEOD/gTpLsanwy

MS DAX reference: https://msdn.microsoft.com/enus/libr...

DAX Fridays Survey: https://onedrive.live.com/survey?resi...

PREVIOUS VIDEO DATEDIFF:    • DAX Fridays! #17: DATEDIFF  

NEXT VIDEO USERELATIONSHIP:    • DAX Fridays! #21: USERELATIONSHIP  


Looking for a download file? Go to our Download Center: https://curbal.com/donwloadcenter

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
Join our DAX Fridays! Series: https://goo.gl/FtUWUX
Power BI dashboards for beginners: https://goo.gl/9YzyDP
Power BI Tips & Tricks: https://goo.gl/H6kUbP
Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB

#daxfridays #curbal #SUBSCRIBE
► Linkedin: https://goo.gl/3VW6Ky