Retrieve List as Text used in Module

My model has a vintage or "Book Year" dimension which is being used as a list - we model that particular year's performance over time. I'm trying to create a module to result in a Boolean at the intersection of the Book Year and the Calendar year. I'm using a YEAR(ITEM(TIME))  = BookYear. However, I cannot seem to find a formula that is relative to the line item. Example: NAME requires that I select a specific year.

Since my model will add and remove years, I'd like this to be automated so it will update as Vintages are added.

Thoughts?

2020-07-01_16-41-49.png

Best Answer

Answers