Dynamic Period Selection on a Dashboard

[adam_mc]

I wish to effectively create a "prompt" on a dashboard based on a date column to enable me to select Current Period vs. Prior Period.
Current Period would represent X months of data within the Data Set/Data Module and Prior Period would be the X months immediately prior to Current Period chosen.
Ideally, the selection of X months (or the driving criteria) would be entirely dynamic in the dashboard by the particular user and would not be known at DataSet/Data Module creation.

The current and prior period need to be calculated at Dashboard run time, not Data Set creation time.
One user may want to compare 1/1/2024 - 12/31/2024 (12 months) as Current Period against 1/1/2023 - 12/31/2023 (immediate prior 12 months to current period of 12 months) as Prior Period.
The next user may want to compare 1/1/2025 - 3/31/2025 (3 months) as Current Period against 10/1/2024 - 12/31/2024 (immediate prior 3 months to current period of 3 month) as Prior Period.

If I was in a Report as opposed to a Dashboard, I would create a calculation based on a prompt for the current period that would determine all the current period rows and all the prior period rows.
I could then setup calculations for variances, etc.

However, I don't know how/if this dynamic calculation is evenpossible in a Dashboard?
Any thoughts/suggestions would be greatly appreciated.

Thanks in advance,
Adam