Slicer filter on N previous Year

[LeroyPaul]

Hello,

I would like to use a slicer on my year field to display the desired year and the 5 previous years.

According to the different solutions that I could find online, I created a 2nd table with years to filter my other table with the following measure (année means year in french) :

Mfilter =

VAR minselected =

SELECTEDVALUE('Year Table'[Année])-5

RETURN

VAR maxselected =

SELECTEDVALUE('Year Table'[Année])

RETURN

IF(AND(MAX('5 - Requêtes BO Consolidé'[Année d'octroi (projet)])>=minselected,MAX('5 - Requêtes BO Consolidé'[Année d'octroi (projet)])<=maxselected),1,0)

However the measure does not achieve what I want, I get the result below for the year 2021 selected (in Year Table):

Année d'octroi (projet)	Mfilter
2015	0
2016	0
2017	0
2018	0
2019	0
2020	0
2021	0

Could you help me? (I specify that I am under Power BI 2020)

Thanks in advance !

[Anonymous · Accepted solution]

Hi @LeroyPaul ,

Check below measure:

Measure = 
var start_ = SELECTEDVALUE('Year Table'[Année])-5
var end_ = SELECTEDVALUE('Year Table'[Année])
var date1 = SELECTEDVALUE('5 - Requêtes BO Consolidé'[Année d'octroi (projet)])
return
IF(date1>=start_&&date1<=end_,1,0)

Make sure there's no relationship between year table and fact table.

Best Regards,

Jay

[LeroyPaul]

Thank you very much, that's exactly it!

[PVO3]

This will problably help you.

[LeroyPaul]

There must be a more simple solution, I can't adapt the solution of the video to my problem