Use a year filter, to filter records with a START and an END date.

[Syndicate_Admin]

Hello community,

I need to put in a report a year filter, to bring me records that their start and end date, are within that year.

example:

id	start	finish
234	02/10/2018	15/12/2019
2345	14/06/2019	18/11/2021
53644	03/10/2019	31/06/2019
542342	14/08/2020	02/03/2023
23432	11/07/2021	17/02/2023

And in the report I have my selector:

• 2018
• 2019
• 2020
• 2021
• 2022
• 2023

If my selection is: 2021

Seberia bring me :

2345	14/06/2019	18/11/2021
542342	14/08/2020	02/03/2023
23432	11/07/2021	17/02/2023

Can you do something with a filter?

[Syndicate_Admin · Accepted solution]

I was able to solve it as follows.

I created a new table to have the years with which I would cross the report using filter.

StartDate = CALENDAR(MIN(Projects[Start]),MAX(Projects[Start]))

Then I created 1 column in my table where the data I need to filter are, to mark with a 1 those that are within that year, and with a 0 those that are not.

Flag = 
var _min=SELECTEDVALUE(StartDate[Inicio].[ Year])

return
 IF(AND(SUM(Projects[FechaInicio].[ Year]) <= _min , SUM(Projects[FechaFin].[ Year]) >= _min), 1 ,0)

Then in the report filter the Flag 1

And so was the report