Daily DAX : Day 379 NEXTDAY

Power BI DAX: NEXTDAY() Function

Function Syntax

NEXTDAY(<dates>)

Description

The NEXTDAY() function returns a table containing a single column of dates representing the next calendar day after the last date in the specified <dates> column or expression.

Note: This is a table function, not a scalar function. It returns a table with one row.

Parameters

Parameter Description
<dates> A column reference that contains dates (typically from a date table).

Return Value

A table with one column named Date and one row containing the date of the day immediately following the latest date in the input column.

Example

Next Working Day = 
VAR LastDate = MAX(Sales[Order Date])
RETURN
    NEXTDAY(FILTER('Date', 'Date'[Date] = LastDate + 1))

Common Use Cases

  • Forecasting the next day after the latest transaction or event.
  • Dynamic date labels in reports (e.g., "Tomorrow's Forecast").
  • Creating dynamic filters for "next day" analysis.
  • Building what-if scenarios starting from the day after current data.
  • Time intelligence calculations that need the next calendar day.

Practical Example

Suppose your Sales table has orders up to October 15, 2025. You want to display a card showing the next business day.

Next Day After Last Sale = 
CALCULATE(
    NEXTDAY(Sales[Order Date])
)

Result: October 16, 2025

Pro Tip: Combine with FILTER or CALCULATE to ensure the next day is a working day (excluding weekends/holidays).

Limitations

  • Returns a table, not a single date — wrap in MIN() or MAX() if you need a scalar.
  • Does not skip weekends or holidays — use custom logic for business days.
  • Requires a date column; does not work with text or numbers directly.

Scalar Version (if needed)

Next Day (Scalar) = 
MIN(NEXTDAY(Sales[Order Date]))

Comments

Post a Comment