How to fill a column on matching ID

[Anonymous]

Hi there,

I have a single table ("Issues") that contains the following fields:

* Key (PK)

* Issue Type

* Epic Link

* Parent Link

Currently, for all Keys where Issue Type = "Epic", there's a record for "Parent Link." What I'd like to accomplish is to have a new column that populates the Parent Link for all Keys, including where Issue Type is Story.

Here's an example:

• In the top table, you'll see ADV-1103 has is Issue Type "Epic" and so has Parent Link SI-45.
• The bottom table shows all the Stories that have Epic Link ADV-1103. I have a custom column called Strategic Initiative that I'd like to return SI-45 for every record shown since the Epic Link is the same.

Here's the Dax I currently have for my custom column. But as you can see, it's not yielding the intended result.

Strategic Initiative = 
CALCULATE(MAX(Issues[Parent Link]),
FILTER(ALL(Issues), Issues[Key]=EARLIER(Issues[Key])))

Any help would be appreciated. Thank you!!

[AlexisOlson · Accepted solution]

It looks like you just need to look up the Epic Link rather than the Key.

Strategic Initiative =
CALCULATE (
    MAX ( Issues[Parent Link] ),
    FILTER ( ALL ( Issues ), Issues[Key] = EARLIER ( Issues[Epic Link] ) )
)

[Anonymous]

That did it - thank you so much!