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.



Best Answer

  • Kanishq17
    Answer ✓

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