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.

CURRENTPERIODEND()

The CURRENTPERIODEND function does not use any arguments.

This function returns a date result.

CURRENTPERIODEND()

In this example, the formula returns the end date from the current period. 

You can set your model's Current Period in Time in the model settings bar.

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.