Fabric Plan Community Logo
Sign in

EOQTR

The EOQTR function returns the end date of the quarter for a given date. References and measures are also accepted as arguments. You can optionally specify an offset to return the end date of a future or previous quarter. This function is commonly used for quarter-end reporting and period-based calculations.

Syntax

EOQTR(date, [offset])

Arguments

  • date: The input date.
  • offset (optional): The number of quarters to add to or subtract from the quarter end date. Positive values move forward, and negative values move backward.

Return value

Returns the end date of the quarter.

Examples

EOQTR("05/29/2026")

Returns 06/30/2026.

EOQTR("05/29/2026", 1)

Returns 09/30/2026 by adding one quarter to the quarter end date of 06/30/2026.

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.