Inactive ralationship

[odada11]

Hello Friends,

Pls i need help with an inactive relationship

i have this 3 table, the relationship between Homeland and security is solid however the production table and Security table is inactive. they are all text and i need to be able to userelationship between Security table and production table to be able to return names of Security personnel and date on the production table;
Tjhis is my expected output;

I am unable to do that presently because the Security table and Production are inactive. The producer id and Admin ID are same.

Kindly help.

[odada11 · Accepted solution]

Thank you so much. i appreciate your help.

[v-yangliu-msft]

Hi  @odada11 ,

I created some data:

Homeland table:

Product table:

Security table:

Here are the steps you can follow：

1. Create calculated column.

names of Security personnel =
MAXX(
    FILTER(ALL('Security table'),
    'Security table'[Group]=EARLIER('Homeland table'[Group])),[Security Personnel])

date =
var _ID=
MAXX(
    FILTER(ALL('Security table'),
    'Security table'[Group]=EARLIER('Homeland table'[Group])),[Admin id])
return
MAXX(
    FILTER(ALL('Product table'),
    'Product table'[Producter ID]=_ID),[Production date])

 2. Result:

If I have misunderstand your meaning, please contact me and provide a pbix without privacy data.

Best Regards,

Liu Yang

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