Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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's avatar
    eliasayyy
    3 years ago

    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"
)

     

     

1 Reply

  • eliasayyy's avatar
    eliasayyy
    Memorable Member
    3 years ago

    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"
)