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


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.


1 Comment
Community Manager
Status changed to: Considered for Future Roadmap
Users Online
Currently online: 404 members 609 guests
Please welcome our newest community members: