I’m a beginner. The goal is to have a virtual, reference column called [Period] in my “Transactions” table to be populated by values from the [Period] column (primary key) in the “Periods” table. The relevant [Period] will be chosen by making sure [Date] in “Transactions” falls between [Start date] and [End date] in “Periods”.
It was quite easy to achieve the opposite effect - to see all Related Transactions of a Period with this expression in a VC -
[Date] >= [_THISROW].[Start date],
[Date] <= [_THISROW].[End date]))
Everything I’ve tried resulted in various errors (too long of a list), but I want to be able to drill down on the period when looking a transaction detail.
Extremely grateful in advance,