No way to get last month of quarter in one line item
As an example, if the first month of the Fiscal Year is Mar 15, I want "May 15" returned because that's the last month of the quarter.
This is my formula (on a line item formatted as Month and no Timescale):
FINDITEM(Time, NAME(PERIOD(END(PARENT(TIME.'Apr 15')))))
However, this returns 'Apr 15' due to this in Anapedia:
"If used with time period, the time period returned is determined by the time period granularity of the result."
"PARENT(TIME.'Apr 15') would need to find the relevant Quarter for this to work, but because of this constraint, it doesn't work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.