How to Dynamically update formula?

Question

I am trying to create a formula that dynamically changes with the dashboard filter that I set.

The formula is:

(
([Total count], [@Months in Date Range])
/
([Total count], [@Previous 12 Months])
) - 1

The Previous 12 months is the previous 12 months that I select from the dashboard filter so say the range is from

2024-09 to 2023-10, then the previous 12 months is 2023-09 to 2022-10.

DRay Liliia_DevX do you know how to do this?

Rafael Ferreira · Accepted Answer

([Total Count], PREV(Months in Date Range],12)) Did the trick!

Ido Darnell · Answer

MikeGre that would work, but then the period in question which is this year vs last year would be fixed in the formula. Using the Filtered Measure plugin, the dates in question, for both the numerator and denominator, will be dynamic based off of the filters selection, respectively