Inherited Value in a Parent Child Pattern

Power Platform - General

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!