Date.IsInCurrentQuarter

Date

Returns true if the date falls within the current calendar quarter.

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

Syntax

Date.IsInCurrentQuarter(dateTime as any) as logical

Parameters

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

Return Value

logical — true if the date is in the current quarter, false otherwise.

Remarks

Date.IsInCurrentQuarter returns true if the input date falls within the same calendar quarter as today (DateTime.LocalNow()). Quarters are defined as: Q1 (Jan–Mar), Q2 (Apr–Jun), Q3 (Jul–Sep), Q4 (Oct–Dec). The function is re-evaluated on each query refresh, making it useful for current-quarter KPI dashboards and reports.

Like all Date.IsIn* functions, this matches the entire quarter period — including future dates in the current quarter. For a quarter-to-date view (only up to today), combine with an additional date comparison: Date.IsInCurrentQuarter([OrderDate]) and [OrderDate] <= Date.From(DateTime.LocalNow()).

In cloud refresh environments (Power BI Service, Dataflows), "today" is determined by the server's UTC clock. If your data is in a local timezone, quarter boundaries may differ from what you expect on your local machine.

Examples

Example 1: Filter this quarter's orders

Table.SelectRows(
    Sales,
    each Date.IsInCurrentQuarter([OrderDate])
)
Result
OrderID
OrderDate
1381/10/2026
2402/20/2026
3423/8/2026

Example 2: Flag current-quarter rows

Table.AddColumn(
    Sales,
    "IsCurrentQuarter", each Date.IsInCurrentQuarter([OrderDate]), type logical
)
Result
OrderID
OrderDate
IsCurrentQuarter
13612/15/2025FALSE
2381/10/2026TRUE
3423/8/2026TRUE

Example 3: Compare current quarter vs. previous quarter

Table.AddColumn(
    Table.AddColumn(
        Sales,
        "IsCurrentQ", each Date.IsInCurrentQuarter([OrderDate]), type logical
    ),
    "IsPreviousQ", each Date.IsInPreviousQuarter([OrderDate]), type logical
)
Result
OrderID
OrderDate
IsCurrentQ
IsPreviousQ
13510/10/2025FALSETRUE
2381/10/2026TRUEFALSE
3423/8/2026TRUEFALSE

Related Functions

Compatibility

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