Filter out dates (past and future) in a table

[jalaomar]

Hi all,

I need help to set some dynamic filtering in a table. I have large list of Projects and what I would like to do is to filter out all projects that have baseline in the future and only include current month baseline.

in the screenshot, there is a filter to only include 2021 ITG4 actual dates and when it comes to ITG4 baseline, i would like to dynamially only show data that is relevant to current month period.

IF ITG4 baseline is 2021-11-15 and we are in september month, this project is not visible but when we are in Novmber month, this project will show in the table.

any idea how to create this dynamic filter/measure?

Many thanks!

BR

J

[jalaomar]

Hi @PaulDBrown , tried out this measure and it is working good! 

super nice and many thanks for the support!!

BR

Jala

[PaulDBrown · Accepted solution]

Hazarding a guess here but try the equivalent to:

Filter out future baselines =

VAR CurrMonth = YEAR(TODAY()) * 100 + MONTH (TODAY())

VAR SelBL = MAX(Table[Baseline])

VAR selP = YEAR(SelBL) * 100 + MONTH (SelBL)

RETURN

COUNTROWS (

FILTER( Table, SelP <= CurrMonth)

)

Then add this measure to the filters for the visual in the filter pane and set the value to  1