Find corresponding data from other row in same table

[jasperdavid]

Hi guys,

I have a data table with several rows of "QIR" (qualit incident report) numbers.

Each QIR has several columns with data in it (e.g. status, description, etc).

However some QIR's are "mother dossiers" and then other QIR numbers have a "Linked QIR" number which refers to this mother dossier.

I want to find the status for the mother dossier for each "daughter".

So for example: I want to calulate a column in powerbi "Actual8Dstatus" where he finds 

for report number QIR20394 -> he finds and fills in the 8D status (4th column) that corresponds with report number QIR 20383.

I managed to do it from another table for a different calculation with lookupvalue but as this is in the same table i keep getting the multiple values error.

So lets say 8D status for 20378 = 5D --> calculated column should show 5D in the row of QIR 20412/20413/20414 etc...

[Icey · Accepted solution]

Hi @jasperdavid ,

I am not very clear about your calculation rules. But this simple example may help you:

Column = 
CONCATENATEX (
    FILTER ( 'Table', [Id] = EARLIER ( 'Table'[Parent Id] ) ),
    [title],
    ", "
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.