Retrieve List as Text used in Module

rhightower

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?

Kanishq17

Use name(item(list)) to get name of each list item

Misbah

@rhightower 

 

See if this helps