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.
See if this helps1