How to use Related to get data from another inactive relationship

You may be able to use the USERELATIONSHIP() function in dax. https://learn.microsoft.com/en-us/dax/userelationship-function-dax

Although, this sounds like something you could also do in Power Query - merging the table and extracting your needed row.

Hi PPStar ,
Thanks for Syk reply.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
All Survery

Date

ID

Relationship

Create a measure

Measure = 
CALCULATE(
    MAX('Date'[Month&Year]),
    USERELATIONSHIP('All Survery'[Completed Date],'Date'[Month&Year])
)

Final output

Best regards,
Albert He

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