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

Anonymous — Thu, 11 May 2023 12:22:02 GMT

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!

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

eliasayyy — Thu, 11 May 2023 12:56:54 GMT

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

topic Re: Return rows whose date are in the future based on current month in DAX Commands and Tips

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

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