Date.IsInCurrentMonth
DateReturns true if the date falls within the current calendar month.
Syntax
Date.IsInCurrentMonth(dateTime as any) as logicalParameters
| Name | Type | Required | Description |
|---|---|---|---|
dateTime | any | Yes | A date, datetime, or datetimezone value to test. |
Return Value
logical — true if the date is in the current month, false otherwise.
Remarks
Date.IsInCurrentMonth returns true if the input date falls within the same year and month as today's date (DateTime.LocalNow()). It matches the entire calendar month from the first to the last day, inclusive — including future dates within the current month. This function is re-evaluated on each query refresh.
Note that this function includes future dates in the current month. If you need only dates up to and including today, use Date.IsInYearToDate restricted to the current month, or add and [OrderDate] <= Date.From(DateTime.LocalNow()) to the filter.
In Power BI Service scheduled refreshes and cloud Dataflows, the "local" time is the server's timezone (usually UTC). If your data dates are in a different timezone, the month boundary may not align with what you expect. This is the same caveat that applies to all Date.IsIn* functions.
Examples
Example 1: Filter this month's orders
Table.SelectRows(
Sales,
each Date.IsInCurrentMonth([OrderDate])
)OrderID | OrderDate | |
|---|---|---|
| 1 | 40 | 3/1/2026 |
| 2 | 41 | 3/7/2026 |
| 3 | 42 | 3/8/2026 |
Example 2: Flag current-month rows
Table.AddColumn(
Sales,
"IsCurrentMonth", each Date.IsInCurrentMonth([OrderDate]), type logical
)OrderID | OrderDate | IsCurrentMonth | |
|---|---|---|---|
| 1 | 38 | 2/20/2026 | FALSE |
| 2 | 40 | 3/1/2026 | TRUE |
| 3 | 42 | 3/8/2026 | TRUE |
Example 3: Filter month-to-date orders only (excluding future dates this month)
let
Today = Date.From(DateTime.LocalNow())
in
Table.SelectRows(
Sales,
each Date.IsInCurrentMonth([OrderDate]) and [OrderDate] <= Today
)OrderID | OrderDate | |
|---|---|---|
| 1 | 40 | 3/1/2026 |
| 2 | 41 | 3/7/2026 |
| 3 | 42 | 3/8/2026 |