Replace value

[Anonymous]

Hello all, I have some trouble finding the solution to the following problem:

I want to replace the value of (row x, column x) with the value of (row n, column n), where the value of (row x, column x) and row n match. To make this problem more clear, see the following tables:

Issue	Epic Link	Epic Name
AA-XXX1		"Name Epic 1"
AA-XXX2	AA-XXX1
AA-XXX3	AA-XXX1
AA-XXX4
AA-XXX5	AA-XXX1
AA-XXX6		"Name Epic 2"
AA-XXX7	AA-XXX6

I would like to replace the Epic Link value with the matching Epic Name value, resulting in:

Issue	Epic Link	Epic Name
AA-XXX1		"Name Epic 1"
AA-XXX2	AA-XXX1	"Name Epic 1"
AA-XXX3	AA-XXX1	"Name Epic 1"
AA-XXX4
AA-XXX5	AA-XXX1	"Name Epic 1"
AA-XXX6		"Name Epic 2"
AA-XXX7	AA-XXX6	"Name Epic 2"

Hopefully someone knows how to solve this, thank you in advance 🙂 

[mahoneypat · Accepted solution]

You can add a DAX column with this expression to get your result.

EpicName2 =
VAR thisepiclink = Issues[Epic Link]
VAR result =
    MINX ( FILTER ( Issues, Issues[Issue] = thisepiclink ), Issues[Epic Name] )
RETURN
    IF ( Issues[Epic Link] = "", Issues[Epic Name], result )

Pat

[Anonymous]

Thank you Pat, that did the job!