- The article discusses creating a Parent Child hierarchy using a Dax Pattern from SQLBI to calculate an inherited value from parent item to child.
- It explains how to pass attributes like assigned person and target date from parent items to child items in Power BI and DevOps.
- The logic involves adding a calculated column to the work items table to lookup target dates in a hierarchical path.
- The DAX formula involves generating a series, then generating a table of work item IDs and their target dates, filtering to rows with target dates, and extracting the target date of the first row.
- The calculated column formula utilizes GENERATE, PATHITEMREVERSE, LOOKUPVALUE, TOPN, and MINX functions in DAX.
- The article demonstrates a step-by-step example with WorkItem IDs and their corresponding target dates in a hierarchical path.
- The Parent Child pattern is highlighted as a useful method, with inherited values providing additional insights into task dependencies and delays.
- The post references the SQLBI Parent Child hierarchy pattern for further information and resources.
Registered users can view the full text for FREE!
Sign In Now!