Variable for Month

[zhaohaifeng]

Hello everyone,

please help to explain the case below. Thanks in advance.

For variable V_MAXMONTH,  We define Let V_MAXMONTH=Month(TODAY()) in data load, my confuse was that  we  cant calculte $(V_MAXMONTH) in TEXT box, and also how to use the month variable in set analysis. Thanks in advance.

Best Regards,

Haifeng

[gianpaolo_31]

One workaround is to create the variable in the Variables section in the Edit Sheet.

[ChennaiahNallani]

Try like below.

in script

Let vMaxMonth = Month(Today());

Expresion

=vMaxMonth

[agigliotti · Accepted solution]

try as below:

Let V_MAXMONTH = Month(TODAY());

in your textbox use only the variable name without $ expansion.

set analysis example:

sum( {< your_month_field = {"$(V_MAXMONTH)"} >} your_measure )

I hope this helps.