Most Recent Selected Month

[fanninam]

How to write an expression equation for:

Select the sum of (full-time employees) for the most recent selected month

[Anonymous · Accepted solution]

Amber,

You need to create a new variable:

=Month(max(DateField))

And add in set analysis:

=sum({<DateField = $(vMaxMonth)>} sales)

[aarkay29]

Create variable 'vMaxMonth'

=MonthStart(Max([DateField]))

Use this Expression

sum({<[DateField]={">=$(=$(vMaxMonth))"}>}Employees)