Control Filter to compare Period 1 to Period 2 in a Pivot


I want to create a control filter that will have the option to filter data period wise and aggregate the measures as per the period selected. There would be two period filters to select and compare them side by side in a pivot.

Is this possible? I could not find any solution to this in the community.

Thanks in advance

Hi @medinib ,

This looks doable by creating a calculated field for period1 and period2. I created two simple calculated fields using the extract() function. Then added them as filters for pivot table. See attached screenshots.

The calculated fields are extract('MM', {Sales Date}) and extract('YYYY', {Sales Date}) for period1 and period2 respectively. You can add formatting and other embellishments by combining functions in the calculated field.

Does that help?


1 Like