Getting Value from another Row

[Anonymous]

hey everyone im trying to do a report where i need to check if the values from "order1" appears in "ReturnId" is this happens i need to get the value of "PointId" from the row where "order1" is filled and put in where the "ReturnId" is the same (i did the example in Excel of what i expect as the result)

PowerBi file 

Is there someway to do this?? Thanks

[selimovd · Accepted solution]

Hey @Anonymous ,

the following calculated column should do the job:

Wanted PointID =
VAR vRowReturnID = Planilha1[ReturnId]
VAR vResult =
    CALCULATE(
        MAX( Planilha1[PointId] ),
        FILTER(
            Planilha1,
            Planilha1[order1] = vRowReturnID
        )
    )
RETURN
    IF(
        vRowReturnID <> BLANK(),
        vResult
    )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Perfect!! thanks a lot