Dynamic Filtering from Table - Period of time

Hi!! hope you can help me! 🙂 

I want to create a slicer which filters with the "User Selection" column from the following table called 'Slicer Period Table'

When the user selects Last Month, Last Qtr or Last Yr, the value that i want to get are the ones in the column "Month index", so i created this measure:

Then I want to calculate some measures that are filter by this slicer, like this:

Total Revenue = CALCULATE([Revenue], ALL(DimDates), AND(DimDates[month index]<=0, DimDates[month index]>= [Period Selection]))

 

The problem is that the measure gives the followig error: "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed." 

i´m very new to DAX so i don´t know how to solve it.

 

Unfortunately i cannot take pictures of my Data tables but i have a common sales table with every transaction that has this 4 columns:

I will always have the amount of sales up to two months before the current day. (For example if we are on April 2021, the last sales I have are from February 2020). Thats why the month index in the 'Slicer Period Table' don´t make sense.

 

 

And a DimDates table like this

 

Thank you!!!! 😊