Return rows whose date are in the future based on current month

[DNAE]

Hello,

I have a table that contains data for different items that have expiration dates.

I would like to be able to filter the table and show rows whose expiration dates are x months into the future.

So, for example, if I'm looking at the table now (in May 2023), I would like to see only rows with expiration dates 3 months into the future (the entirety of August 2023).

If I'm looking at the table in October 2023, I would like to see only rows with expiration dates 5 months into the future (the entirety of March 2024).

Only the month should be taken into consideration.

The table looks like this:

Any help would be greatly appreciated!

[eliasayyy · Accepted solution]

for caluclated column 

Near Expiry = 
IF(
    MONTH(TODAY()) + 3 >= MONTH('Table'[Expiry Date]),
    "Yes",
    "No"
)

for measure

Near Expiry Measure = 
IF(
    MONTH(TODAY()) + 3 >= MONTH(MAX('Table'[Expiry Date])),
    "Yes",
    "No"
)