Max date return of date

Rich_Talbot — Thu, 20 Jun 2019 10:37:13 GMT

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])

Re: Max date return of date

sunny_talwar — Thu, 20 Jun 2019 10:42:40 GMT

Try this may be

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