Concatenate results of two member filters

JoãoRodrigues
New Contributor

How do I concatenate 2 member filters?

Something like this:

JooRodrigues_0-1724431094761.png

 

3 REPLIES 3

TGG_Alex
Contributor

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.

 

Cheers,
A.

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

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

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?

 

Cheers,
A.