Forum Discussion

odada11's avatar
odada11
Helper I
3 years ago
Solved

Inactive ralationship

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 i...
Need Help
Tips and Tricks
  • odada11's avatar
    odada11
    3 years ago

    Thank you so much. i appreciate your help.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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