Max date return of date

[Rich_Talbot]

Hi, I am trying to sum a column of numbers in this case FTE but based on the Month column equalling the latest month.

What I have is a data sheet that is added to each month and the latest months data is added with the current months date.

So I want to sum the FTE but only when the month equals the current month which will be the MAX date however my expression has an error.

Can anyone help, the expression is as follows:

Sum({<[Monthly Bulletin Data.Month]={(Date(Max([Monthly Bulletin Data.Month])))}>}[Monthly Bulletin Data.Person FTE])

[sunny_talwar · Accepted solution]

Try this may be

Sum({<[Monthly Bulletin Data.Month] = {"$(=Max([Monthly Bulletin Data.Month]))"}>} [Monthly Bulletin Data.Person FTE])