How to compare customize period value

[Amanda]

hi team
I want to know how to ：Dynamic compare two period value：for example，this month sum of value with last month，today is 2/6 then compare the sum value of （2/1 ～2/6） with （1/1 ～1/6）

[Naveed]

Hi
check this post.

Creating period comparisons with QuickSight's periodOver and periodTo functions

This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop. We will update the data to the current date so your calculations are realistic. If you do not have a QuickSight account please follow the instructions in the Initial Setup. Instructions to create the dataset can be found in Exercise 1 of the Build your first dashboard. Create an analysis for the dataset. The following steps show you how to create visuals to show data from the current year,…

ifelse(
${PeriodStarting}=‘Day’,truncDate(“DD”,{Adjusted Order Date}),
${PeriodStarting}=‘Month’,truncDate(“MM”,{Adjusted Order Date}),
${PeriodStarting}=‘Quarter’,truncDate(“Q”,{Adjusted Order Date}),
truncDate(“YYYY”,{Adjusted Order Date}))

regards,
Naveed Ali