Date.IsInNextQuarter

Date

Returns true if the date falls in the next calendar quarter.

Examples on this page use shared sample tables. View them to understand the input data before reading the examples below.

Syntax

Date.IsInNextQuarter(dateTime as any) as logical

Parameters

NameTypeRequiredDescription
dateTimeanyYesA date, datetime, or datetimezone value to test.

Return Value

logical — true if the date falls in the quarter immediately after the current quarter, false otherwise.

Remarks

Date.IsInNextQuarter returns true if the input date falls within the calendar quarter immediately following the current quarter (as determined by DateTime.LocalNow()). For example, if today is in Q1 (Jan–Mar), this function returns true for any date in Q2 (Apr–Jun). The function is re-evaluated on each query refresh.

This function matches exactly one quarter: the next one. For a broader forward window spanning multiple quarters, use Date.IsInNextNQuarters. To include the current quarter as well, combine with or Date.IsInCurrentQuarter([OrderDate]).

Quarters are always standard calendar quarters. There is no support for custom fiscal quarter definitions. If your fiscal year starts in a month other than January, compute the quarter boundaries manually using Date.AddMonths and Date.StartOfQuarter.

Examples

Example 1: Filter orders expected in the next quarter

Table.SelectRows(
    Sales,
    each Date.IsInNextQuarter([OrderDate])
)
Result
OrderID
CustomerName
OrderDate
143Alice4/10/2026
244Bob5/18/2026
345Charlie6/25/2026

Example 2: Flag next-quarter orders

Table.AddColumn(
    Sales,
    "IsNextQuarter", each Date.IsInNextQuarter([OrderDate]), type logical
)
Result
OrderID
OrderDate
IsNextQuarter
1423/8/2026FALSE
2434/10/2026TRUE
3467/1/2026FALSE

Example 3: Flag current and next quarter together

Table.AddColumn(
    Sales,
    "CurrentOrNextQ",
    each Date.IsInCurrentQuarter([OrderDate]) or Date.IsInNextQuarter([OrderDate]),
    type logical
)
Result
OrderID
OrderDate
CurrentOrNextQ
1423/8/2026TRUE
2434/10/2026TRUE
3467/1/2026FALSE

Related Functions

Compatibility

✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks