I want to be able to show past year values based on year selected in the slicer

[Vilas_Techie]

Hi 

I have a dynamic slicer which: 

How can I write a DAX expression that show only the Sales of the last years based on the current selection of the year.
For Example:
-If I select 2015, the table should show only sales for the years 2015, 2014, 2013, 2012, 2011,2010
-If I select 2012, the table should show only sales for the years 2012, 2011 2010, 2009, 2008,2007

just want to note that I'm new to PowerBi so I really appreciate your help.

[Gengar · Accepted solution]

Hi @Vilas_Techie ,

This is my data:

You can create a new date table and use the data to create a slicer:

Then create a measure as a filter:

Measure = IF(YEAR(MAX('Table'[Date]))<=YEAR(SELECTEDVALUE('Date'[Date])),1)

Then it will work!