Define Variables

Define Actions

Build visualizations

Ensure there is a table with a date field that isn't connected to the other tables.

The date field used in this example should be a date type field.
​

Set the aggreagtion

Open the filter section in the measure and define two filters for a date field (not the date field from the island table), comparing the field to start and end parameters.

Create another measure for the previous period, also including parameter filters.
It's essential to use different parameter names.

Create a measure to calculate the period-over-period, combining the two measures.

Ensure that the parameter names are identical to the parameters used in the previous measures.
​

Define four string variables with the same name as the parameters in the measures created in the previous step and assign them default values.
Define to Numeric variables that will get the value of the start and end of the period.

Define an action that updates the variables value for periods after each selection in the island date.

This block assigns the min and max values to the numeric variables and then calculates the values for the string variables used in the measures.

Optionally, you can add one more block that will create a text presenting the periods for the user
The action will be something like this.

​

Duplicate the block and create an event on Workbook open to set the default periods.
In the image below the default period is set to YTD

Create a table with the three measures created and a selected dimension.
​

After adding the measures, ensure that the parameters are tied to the variables.
​

​

Add a Date picker control and use the island date field
​

​

Add a Text object and use the variable that describes the selected periods as the content.
​