3 Replies Latest reply: May 10, 2017 2:47 PM by Sunny Talwar RSS

    Set analysis within set modyfier

    Simon Brulotte

      hi,

      I have a set analysis that works well:

      =maxstring({<[Période fermée] ={'1'}>}[Année-période financière])

       

      This gives me 2017-09. basically, year 2017, 9th period. 9th period in my calendar is january.

      I want to bring back january as my result so I tried this set analysis:

       

      =only({< [Année-période financière]={'$(maxstring({<[Période fermée] ={'1'}>}[Année-période financière]))'}>} Mois)

       

      Gives me a blank in a text box. Is there something I'm not writting properly in my expression?