Fabric Plan Community Logo
Sign in

ADDQTRS

The ADDQTRS function adds or subtracts a specified number of quarters from a date. It is commonly used to calculate future or past quarter-based reporting periods.

Syntax

ADDQTRS(date, value)

Arguments

  • date: The input date. This can be a date value, measure, or reference.
  • value: The number of quarters to add or subtract. Use a negative value to subtract quarters.

Return value

Returns the calculated date.

Examples

ADDQTRS("05/29/2024", -1)

Returns 02/29/2024 by subtracting 1 quarter (3 months) from the input date.

ADDQTRS("05/29/2026", 2)

Returns 11/29/2026 by adding 2 quarters (6 months) to the input date.

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.