Need Help

[suvechha_b]

Can anyone suggest how to write the expression :

=sum({<{vMaxYear},{vMPeriod}>}[Actual Units])

Note :

vMaxYear,vMPeriod are variables.

[suvechha_b]

How to calculate sum([Actual Units]) depending on two variable given below

vMaxYear , vMPeriod .

How to write the expression ?

Thanks,

[mphekin12]

Will this work:

sum({<Year={$(vMaxYear)}, Period={$(vMPeriod)}>} [Actual Units])

[nizamsha]

sum( {$<year={"$(=Max(year))"},month={"$(=Max(Month))"}>}actual unit)

[v_iyyappan]

Hi,

What you arrive in period variable? Whether its date means please check the date format are same in variable and Period column name.

Use like this

=Sum({<Year={$(vMaxYear)}, Period={$(vMPeriod)}>}[Actual Units])

Regards,