How can i create a new colum, which is the last 30days of a last 30 days?

[JoanElGran1899]

Hi everyone,
I am here again with more doubts to solve, can anyone help me? jeje

My problem is the next one:

I have two slicers of different calendars tables and the first one I filtered about the last 30 days, but the second one I have to filter it about the last 30 days of the first one.

I mean, the first slicer  (16/08/2021-14/09/2021) and the second one ( 17/07/2021-16/08/2021).

The first slicer was quite easy to did it:

But with the second slicer, I have no idea to do it automatic...

Kind regards,
att:JoanElGran ( the biggest one)

[amitchandak · Accepted solution]

@JoanElGran1899 , as of now, you can not initialize the range slicer based on some function 

You can create a column in your date table and use that

Date Type = SWITCH(TRUE(),'Date'[Date]<=TODAY() && 'Date'[Date] >= today() -30,"Last 30"
,'Date'[Date]<=TODAY()-31 && 'Date'[Date] >= today() -60,"Last to Last 30"
,"Other")