NEXTDAY
Returns the calendar day after each date in the filter context.
NEXTDAY(<dates>)Returns: A table of dates.
What it does
NEXTDAY moves the visible date forward one calendar day. Treasury and collections teams use it to see what is due tomorrow, such as receipts expected from customers or payments scheduled for release. It works on calendar days, so a Friday's next day is a Saturday even when the bank is closed.
Syntax and arguments
- dates: the date column of the Calendar table. Required.
Example
A treasury team wants the expected customer receipts for the next day, based on the due date of each open receivable. The receivables table is related to the Calendar on its due date.
Receipts Due Tomorrow =
CALCULATE(
SUM('Receivables'[OpenAmount]),
NEXTDAY('Calendar'[Date])
)
On a day in the middle of the week, the measure adds up the open amounts due the following day. The figure is a forecast, so it is only as good as the due dates and the payment behavior behind them.
Example: a second, different use
Vendor payments scheduled for the next day, shown on a payment run approval screen.
Payments Scheduled Next Day =
CALCULATE(
SUM('Payment_Schedule'[Amount]),
NEXTDAY('Calendar'[Date]),
'Payment_Schedule'[Status] = "Approved"
)
Things to watch
- NEXTDAY returns the next calendar day, not the next business day. A Friday's next day is Saturday, so a payment due on Monday is not found by a Friday measure.
- For the next business day, add a workday flag to the Calendar and use it as a filter.
- The forecast is only as good as the data behind it. A receivable with no due date does not appear.
- The Calendar must be complete, and the relationship must be to the due date column, not to the invoice date.
In business terms
NEXTDAY supports the daily cash forecast, the list of receipts to chase, and the payment run approval. Treasury teams look one day ahead to make sure cash is in place for the next day's payments.