• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Downloads
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / PATHITEMREVERSE

PATHITEMREVERSE

posted on August 31, 2017

« Back to Glossary Index

Syntax

PATHITEMREVERSE(<path>, <position>[, <type>])

Tutorial with example

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

Download example file:

Link to demo file here.

Remarks

  • This function can be used to get an individual item from a hierarchy resulting from a PATH function.
  • This function reverses the standard order of the hierarchy, so that closest items are listed first, For example, if the PATh function returns a list of managers above an employee in a hierarchy, the PATHITEMREVERSE function returns the employee’s immediate manager in position 2 because position 1 contains the employee’s id.
  • If the number specified for position is less than one (1) or greater than the number of elements in path, the PATHITEM function returns BLANK.
  • If type is not a valid enumeration element an error is returned.

This DAX function is not supported for use in DirectQuery mode.

 

Was this helpful?
[Total: 1    Average: 5/5]
See Also:
  • PATH
  • PATHCONTAINS
  • PATHITEM
  • PATHLENGTH
« Back to Index

Reader Interactions

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +12,500 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 6
722 13 – Västerås
Sweden

OrgNo:5569680852 | VAT:SE556968085201

 

Location:

© Copyright 2014-2019 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In