PBI Slicer set EndDate Todays Date and StartDate is 1 year

[AppVine]

Hi Everyone, 

Good day! 

I have a slicer with start date and end date. My problem is that, my start date will not automatically set to todays date. 

What I want is to set as default is EndDate should todays date and StartDate is 1 year of current date

[MahyarTF]

Hi,

In my opinion, you need to create another date dimension that is started from today and ends based on another field in another table or whatever you want) and then link the particular new date table to your Date dimension.

You could use the below code to create a new date table that is started from the current date :

CurrDate = DATESBETWEEN('Date'[Date], TODAY(), max('Date'[Date]))

*** Date[Date] is the Date dimension 

Thanks for your Kudos and please mark it as a solution if it helps you.

[AppVine]

got error: 

I used code: 

CurrDate = DATESBETWEEN('QI_Data_RPN'[IncidentDate], TODAY(), max('QI_Data_RPN'[IncidentDate]))

If I use code below. It returns empty date

CurrDate = DATESBETWEEN('Date'[Date], TODAY(), max('QI_Data_RPN'[IncidentDate]))