SHOWMEASUREBETWEENPERIOD

Displays measures in the defined time frame. Can be used to display a specific measure for a particular duration, such as months, quarters, or years.

Syntax

SHOWMEASUREBETWEENPERIOD([dates], [measures])

Arguments

dates – Array of dates during which to display measures. Required.

measures - Array of measures to be displayed. Required.

Example

SHOWMEASUREBETWEENPERIOD(LASTNMONTH(2), [[Actuals],[Plan]])
//Displays the Actuals and Plan for the last 2 months