Forum Discussion

JoãoRodrigues's avatar
JoãoRodrigues
New Contributor
4 months ago

Concatenate results of two member filters

How do I concatenate 2 member filters?

Something like this:

 

  • No need for "+Month".

    T#|!Param_YearSelect!||!MonthSelect!|

    If you need to construct 2024M2 and they are separate parameters, just make sure your month parameter is expressed in M1 to M12 terms.

    So if you use a delimited list, you can set description to be Jan to Dec but returned value as M1 to M12.

     

    • JoãoRodrigues's avatar
      JoãoRodrigues
      New Contributor

      So, it's not possible to concatenate 2 functions?

      The way you propose, I would have to have 2 buttons for time.

      • TGG_Alex's avatar
        TGG_Alex
        Contributor

        Based on your syntax, are you trying to essentially get the prior year of the same month?

        E.g., |!Jumia_Conso_Act!| = 2024M4

        Desired result = 2023M4

        If so, you can try T#PeriodPrior12(|!Jumia_Conso_ACT!|)

        There are numerous Time Functions available to achieve different dynamically derived time members so experiment with those?