Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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...
Solved! Go to 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.
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.