More efficient expression?

[Patrick_Paul]

I have the following expression where I need to get the value of the field "Account: Gold Class Renewal Date" from the GC Requirements table that has a ref into the table this virtual column resides in.  Here's the expression:

text(any(select(GC Requirements[Account: Gold Class Renewal Date],[_THISROW].[Org ID]=[Org Id])))

This is impacting performance.  Is there a better way to do this?  All related rows should have the same renewal date, which is why I'm using "Any", I just need to capture it once.

Thanks in advance!

[peterson]

It looks good. The TEXT expression is really necessary? If yes, it looks fine

[lynchk21 · Accepted solution]

I believe you should be able to use a reference or deference function depending on which table is the parent.

Reference to child record to parent:

Text(ANY([Org Id].[Account: Gold Class Renewal Date]))

Or

Dereference from parent to child records:

Text(ANY([Related GC Requirements][Account: Gold Class Renewal Date]))

[Patrick_Paul]

The above suggestion is cleaner code, so I'm using it.  The performance analyzer surprisingly says it made almost no difference in compute time, however.  Thanks for the help!