Filter dates range from X date till today always

[pedroccamaraDBI]

Hello all,
I would like to, everytime i open my report, it shows the date range from whatever date i've choose till today's date.
I know we can show all dates before today, but today included. But i would like to see on that range date filter, on the second box, always the date of today.
Is this possible?
Thank you all

[amitchandak]

@pedroccamaraDBI , I doubt you can initialize range base slicer. 

You can create a column and set list

example

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

You can log an idea https://ideas.powerbi.com/ideas/

[pedroccamaraDBI]

Hello @amitchandak 
The problem is that i don't know, ever, when is gonna be the end date. What i do know is that it can't be after today. This is the date filter i have.

So, i've add a column on my date table, IsAfterToday = IF (Dates[Date] > TODAY(), 1, 0) and on that date filter, i've add this one.
What i would like to show, the "From date", its not important, but the "To Date" is should always be todays date, you know?
That's it. Can you help?

[amitchandak]

@pedroccamaraDBI , I doubt that, can default. Try to end your calendar of today. or try relative date slicer

[pedroccamaraDBI]

i did all that and it's not working still