The CURRENTPERIODEND function returns the end date from a model's current period.
For example, you can use the CURRENTPERIODEND function to ensure that a formula only applies to a specific week in the current period.
Syntax
CURRENTPERIODEND()
Arguments
The CURRENTPERIODEND function does not use any arguments.
This function returns a date result.
Syntax example
CURRENTPERIODEND()
In this example, the formula returns the end date from the current period.
Additional information
You can set your model's Current Period in Time in the model settings bar.
Examples
PERIOD(CURRENTPERIODEND() + 1)
In this example, the formula returns the first time period after the model's current period. If the model's current period is Jan 20, it returns Feb 20.
