Plaza 365
Plaza 365

No results found for your search

RegisterLog in

2

Visit article

Power Platform - General

Category

Sep 30, 2024

Published date

Text

Article Type


AI Summary

  • 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!