Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Try this may be
Sum({<[Monthly Bulletin Data.Month] = {"$(=Max([Monthly Bulletin Data.Month]))"}>} [Monthly Bulletin Data.Person FTE])
Try this may be
Sum({<[Monthly Bulletin Data.Month] = {"$(=Max([Monthly Bulletin Data.Month]))"}>} [Monthly Bulletin Data.Person FTE])