Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replace value

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, colu...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you Pat, that did the job!